OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Replace command not working Oracle 10GR2 By: nmd_group on Tue, 18 June 2013	3	1644	Tue, 18 June 2013 05:50 By: Michel Cadot
NUMBER SERIES (merged by MC) By: MEGHAtarun on Sat, 15 June 2013	20	5629	Tue, 18 June 2013 03:19 By: ThomasG
sending arabic sms to gsm from oracle database 11g By: bahaelsharif on Sun, 16 June 2013	29	12297	Tue, 18 June 2013 03:14 By: Michel Cadot
order by By: lavkumar78 on Mon, 17 June 2013	13	2492	Mon, 17 June 2013 22:18 By: BlackSwan
enhancing performance of join oracle 10g By: enxsnx on Mon, 17 June 2013	3	1519	Mon, 17 June 2013 12:41 By: Michel Cadot
update issue oracle sql developer,oracle 11g By: oracle_doubt on Fri, 14 June 2013	18	3509	Mon, 17 June 2013 10:53 By: Lalit Kumar B
spooling xml column into one single row 9 By: perikaceo on Mon, 17 June 2013	5	2086	Mon, 17 June 2013 09:16 By: perikaceo
How to schedule the job to run evry Sunday at 12 P.M IST Oracle 11g By: ajaykumarkona on Tue, 11 June 2013	4	4205	Mon, 17 June 2013 01:40 By: ajaykumarkona
Getting all data in a single row Oracle Database 11g11.2.0.3.0 - 64bit By: wolfking on Sun, 16 June 2013	8	2333	Sun, 16 June 2013 17:27 By: BlackSwan
get End time by query between start time and duration Oracle Form6i By: medisys on Sun, 16 June 2013	5	2423	Sun, 16 June 2013 08:43 By: medisys
MULTIPLICATION OF NUMBER By: MEGHAtarun on Sat, 15 June 2013	1	1414	Sat, 15 June 2013 12:48 By: Michel Cadot
Stored Procdure with multiple table join with aggregate functions. Oracle 9i or Oracle 10g By: Sheetalraju on Sat, 15 June 2013	2	1385	Sat, 15 June 2013 04:31 By: Littlefoot
Update query for 2 lakhs rows By: satyamhcl on Wed, 12 June 2013	16	5193	Sat, 15 June 2013 01:02 By: sss111ind
Query help 11.2.0.2.0 By: guesthyd on Fri, 14 June 2013	3	1561	Fri, 14 June 2013 23:59 By: guesthyd
Creating a loop (merged 2) Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production ( 1 2) By: wolfking on Wed, 12 June 2013	50	6825	Fri, 14 June 2013 18:34 By: wolfking
Getting the next data with loop Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: wolfking on Fri, 14 June 2013	3	1967	Fri, 14 June 2013 16:57 By: ThomasG
SQL Query 10g By: userora on Thu, 13 June 2013	30	4206	Fri, 14 June 2013 15:38 By: pablolee
Issue with Rownum Oracle 11g By: rpuser on Fri, 14 June 2013	1	1286	Fri, 14 June 2013 11:28 By: Michel Cadot
Need help with inserting bulk records to the table By: diablog on Fri, 14 June 2013	5	1632	Fri, 14 June 2013 10:43 By: BlackSwan
Need all invalid records Oracle Database 11g Express Edition Release 11.2.0.2.0 -, Windows 7 By: shumail on Wed, 12 June 2013	15	4086	Fri, 14 June 2013 07:15 By: Lalit Kumar B
UTL_FILE READ TAKING TIME ORACLE 9i By: umeshchandraseth on Fri, 14 June 2013	19	3869	Fri, 14 June 2013 03:01 By: cookiemonster
CONVERSIONS By: DUTTA@TARUN on Fri, 14 June 2013	4	1298	Fri, 14 June 2013 01:25 By: Michel Cadot
How to query for columns without using column names TOAD PLSQL By: bws93222 on Wed, 05 June 2013	4	1658	Thu, 13 June 2013 16:50 By: bws93222
Help in SQL oracle 11g By: rocky_007 on Thu, 13 June 2013	21	3167	Thu, 13 June 2013 14:30 By: Michel Cadot
ENTER(line break) issue in name field column oracle 10g By: rajasekhar857 on Wed, 12 June 2013	4	2101	Thu, 13 June 2013 09:58 By: Michel Cadot
retrieve deleted rows in oracle 10g By: mohamednawin@gmail.com on Thu, 13 June 2013	7	2055	Thu, 13 June 2013 08:38 By: gazzag
add parenthesis to query By: hassan08 on Mon, 10 June 2013	2	1423	Thu, 13 June 2013 06:27 By: hassan08
Oracle - Word bookmark 64bit By: wolfking on Wed, 12 June 2013	33	5420	Thu, 13 June 2013 01:40 By: Littlefoot
Can we pass REF_CURSOR to externel procedure Oracle 11g By: ashwani0301 on Thu, 13 June 2013	2	1305	Thu, 13 June 2013 01:40 By: ashwani0301
Like operation for multiple values oracle 11g By: babhuko on Wed, 12 June 2013	2	1523	Wed, 12 June 2013 23:55 By: Michel Cadot
sys_guid() help with bulk insert 11g r2 By: rexi on Wed, 12 June 2013	5	2240	Wed, 12 June 2013 16:13 By: rexi
Need help to read CLOB and use in SQL query Oracle Database 11g Release 11.2.0.1.0 - 64bit Production By: upanwar on Tue, 11 June 2013	18	3567	Wed, 12 June 2013 13:02 By: Lalit Kumar B
ORA-14251: Specified subpartition does not exist By: scottwmackey on Wed, 12 June 2013	4	11015	Wed, 12 June 2013 12:22 By: Michel Cadot
sql query with where condition By: satyam_mitm@yahoo.com on Wed, 12 June 2013	6	1775	Wed, 12 June 2013 11:01 By: Michel Cadot
ORDER BY By: mercyjhansi on Tue, 11 June 2013	14	1958	Wed, 12 June 2013 10:51 By: rakeshramm
Query to get whether a string contains 2 upper characters and numbers using regular_exp Oracle 10g By: rakeshramm on Wed, 12 June 2013	12	2513	Wed, 12 June 2013 10:37 By: rakeshramm
Reading mutiple files 11gr2 By: rexi on Wed, 12 June 2013	5	1934	Wed, 12 June 2013 10:00 By: rexi
oracle procedure to read all the text oracle 9i,windows xp By: niranjan479 on Wed, 12 June 2013	15	2747	Wed, 12 June 2013 09:48 By: BlackSwan
A question about ORA-01466 error code in a procedure with SET TRANSACTION READ ONLY By: dariyoosh on Wed, 12 June 2013	0	2387	Wed, 12 June 2013 06:52 By: dariyoosh
TRIGGER HELP By: Virusble on Tue, 11 June 2013	23	3058	Wed, 12 June 2013 05:00 By: Littlefoot