Forums Page 90
-
How to sum these output values
Hi I need sum the month totals SELECT region_name, area_name ,SUM (CASE WHEN SUBSTR(yr_mth,5,2) = '07' THEN sales_target END) AS jul ,SUM (CASE WHEN…
-
distinct rows
Hi version 10.2.0.3 I have a query output something like the following ID name 1 aaaa 1 axbd 1 adga 2 sgfd 2 dfdg 3 dfdff 4 dfdff my desired result…
-
UTL File problem
Hi I have a file in certain path with the following permissions (The file is a dummy file without any contents)--Zero byte file. Permissions…
-
Update data to upper case in parent/child tables
Hi Gurus! In production we have a product table and which is being reference by many tables making it parent child relationship. By mistake, we…
-
Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0). I trying run create or replace package ....etc. I received ORA-21700. I find recommened action for that error…
-
update 2 columns by doing inner 2-column query
Hi, is something like this possible? update contract_all set col1,col2 = (SELECT col1,col2 FROM tab1 WHERE id = 141 and status='a') where co_id=141…
- Advertisement
-
Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database using a single select statement or must a select…
-
WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod PL/SQL Release 10.2.0.2.0 - Production Forms 32 Bit Version 10.1.2.0.2 (Production)…
-
Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME'; and have the output as: COL1, COL2, COL3 instead of: COL1…
-
send message to the java application
Oracle 10g with Windows platform. I have a java application that periodically pings the database table to see if it contains the specific row so that…
-
How to give the privillege for triggers?
Hi, How to give the privillage for triggers to particular user? Please let me know, if it is possible. Thanks
-
ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp database : XE there is a table (transito) with two fields of clob datatype. in a plsql code, there is an update statement in this…
-
utl_file open error
i have file in the unix path Path /popdev01/pop/popdevb/tfi/ File name: qua01 this path is hard coded in the table PQ10. i will be taking this value…
-
comparing tables across databases sql refinement ideas required
Hi all Via pl/sql I need to ensure that data between tables in different databases match (i.e. standby db and development db) I have made the…
- Advertisement
-
How to change www in url with a specified name
Hi I'm trying to change the url http://www.sitename.com/apparels to something like below http://apparels.sitename.com/apparels in PHP. If anybody can…
-
upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please tell me how can i restrict that
-
cookie problem
I hv a website url In this site main menu functionality based on cookie when user click on particular menu the visited menu change its color and…
-
Amend code to allow multiple attachments
Hi I have a php page that allows the user to browse to a file (image) then sumbit, the confirmation page then has the following code which uploads…
-
simplexml_load_file and rss problem
Hi, I have a problem parsing an rss feed using simplexml_load_file - this is strange as i have used the same code to parse literally 1000s of…
-
Table colours fail when extra row added
Hey Gurus, I got a weird problem with formating the colour of a table made in php. Everything works fine when i use 5 rows each row has an…