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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	41	182655	Thu, 23 July 2015 10:23 By: Lalit Kumar B
Pulling hair out trying to use table function Oracle 11 By: jbarker36 on Fri, 12 October 2018	16	740	Tue, 16 October 2018 13:44 By: JPBoileau
Written Assignment-Printing a Record Using an If Statement By: cwilliam912 on Sun, 14 October 2018	19	937	Tue, 16 October 2018 13:33 By: cwilliam912
DR Failure By: msyogi on Tue, 16 October 2018	6	283	Tue, 16 October 2018 08:58 By: joy_division
Count of Pending, Failed, Running, Completed records Oracle 12c By: user_5678 on Mon, 15 October 2018	7	573	Tue, 16 October 2018 08:02 By: EdStevens
DBMS_SCHEDULER Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: chat2raj.s on Tue, 16 October 2018	4	249	Tue, 16 October 2018 07:23 By: John Watson
redundant output By: suji6281 on Tue, 16 October 2018	8	317	Tue, 16 October 2018 07:01 By: suji6281
Recursive query By: zhaoquer on Tue, 16 October 2018	8	315	Tue, 16 October 2018 06:40 By: zhaoquer
Rownumer WITH OUT Order by Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 29 September 2018	13	1078	Mon, 15 October 2018 14:33 By: Bill B
Convert Date in String field (merged) By: ssmith001 on Tue, 18 September 2018	21	1833	Mon, 15 October 2018 14:09 By: Bill B
Help with bitmap join indexes 11g By: Paul Newman on Mon, 08 October 2018	2	608	Mon, 15 October 2018 10:39 By: Bill B
Duplicating Excel COUPNCD function in PLSQL. By: SATHISHENU on Tue, 04 September 2018	9	1049	Sun, 14 October 2018 12:48 By: Barbara Boehmer
Calculate problem , help me By: zhaoquer on Sat, 13 October 2018	11	668	Sat, 13 October 2018 04:01 By: zhaoquer
Complex SQL Quiries for me 11g,12c By: graphe on Fri, 12 October 2018	6	592	Fri, 12 October 2018 16:18 By: pablolee
Error in converting CLOB to BLOB SQL*Plus: Release 11.2.0.1.0 By: vinodkumarn on Mon, 27 August 2018	6	1008	Fri, 12 October 2018 11:55 By: vinodkumarn
Return Rows when no data exists Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: ssmith001 on Wed, 10 October 2018	2	304	Wed, 10 October 2018 15:53 By: John Watson
TRIM function Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 By: wtolentino on Wed, 10 October 2018	3	1791	Wed, 10 October 2018 09:17 By: wtolentino
https://community.oracle.com/message/14958599#14958599 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: suhaas on Tue, 09 October 2018	1	556	Tue, 09 October 2018 16:42 By: BlackSwan
Help required on assigning value to Tabletype variable! By: ramya29p on Tue, 09 October 2018	5	631	Tue, 09 October 2018 08:22 By: Solomon Yakobson
How to merge 2 rows from a table to 1 row (2 columns) By: dsslim on Mon, 08 October 2018	2	525	Mon, 08 October 2018 20:58 By: dsslim
HELP NEEDED IN COMPILING PACKAGE ORACLE 11 G By: sanjeev.sharda on Thu, 04 October 2018	7	828	Mon, 08 October 2018 04:28 By: sanjeev.sharda
Assign same Group id to rows By: purnima1 on Sat, 06 October 2018	3	486	Sat, 06 October 2018 07:54 By: Michel Cadot
How to read correctly the execution plan in oracle, both in tree and tabular mode? By: TheMatrix on Thu, 04 October 2018	6	855	Sat, 06 October 2018 07:49 By: TheMatrix
If the sting value more then 3 separated need to split into 2nd line By: mist598 on Fri, 05 October 2018	4	558	Fri, 05 October 2018 07:26 By: Michel Cadot
regular expression substring to get the string that is delimited by a comma Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 By: wtolentino on Wed, 03 October 2018	2	585	Thu, 04 October 2018 06:54 By: wtolentino
Optimal Chunk size for update of 50M record table Oracle 11g RAC, Linux OEL 6 By: Andrey_R on Wed, 03 October 2018	12	658	Wed, 03 October 2018 11:13 By: BlackSwan
Last and Sum in group by 11.1.2.10 By: OraFerro on Thu, 27 September 2018	2	675	Mon, 01 October 2018 23:36 By: OraFerro
Creating a function Oracle 11g By: Odigitrium on Sat, 22 September 2018	6	820	Mon, 01 October 2018 14:08 By: Solomon Yakobson
PL/SQL: could not find program unit being called when calling packages By: venki8286 on Wed, 19 September 2018	32	1763	Mon, 01 October 2018 08:57 By: Bill B
Listing all dates in a date range Oracle, 11g Release 2, Windows 7 By: Subrata05005 on Sat, 29 September 2018	5	567	Sat, 29 September 2018 15:52 By: Littlefoot
Query for Matching Record --> as much matches By: myclassic on Thu, 27 September 2018	12	895	Fri, 28 September 2018 04:59 By: myclassic
Using LISTAGG in a subquery Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: ssmith001 on Thu, 27 September 2018	3	535	Thu, 27 September 2018 11:27 By: ssmith001
Create collection of nested table By: purnima1 on Wed, 26 September 2018	8	1011	Wed, 26 September 2018 09:21 By: purnima1
In Class with sub query By: nagaraju.ch on Tue, 25 September 2018	3	871	Wed, 26 September 2018 09:09 By: Roachcoach
How to Find the Parent of Index Organized Table Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: wtolentino on Tue, 25 September 2018	6	696	Tue, 25 September 2018 13:01 By: wtolentino
Writing Arabic Text using UTL_FILE Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production By: chat2raj.s on Mon, 24 September 2018	1	797	Mon, 24 September 2018 06:05 By: msol25
SQL code syntax Understanding By: anirdesh on Sat, 22 September 2018	3	737	Sat, 22 September 2018 14:29 By: Solomon Yakobson
Cast to index by table By: purnima1 on Fri, 21 September 2018	3	699	Fri, 21 September 2018 01:26 By: _jum
OE SAMPEL SCHEMA ORACLE 12.2.0.1.0, window 10 By: Bilal Khan on Thu, 20 September 2018	22	1032	Thu, 20 September 2018 09:48 By: BlackSwan
query performance EBS R12, db-10.1.1.2 By: annu-agi on Wed, 19 September 2018	7	819	Wed, 19 September 2018 03:24 By: Michel Cadot