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
How to make a trigger on the table for the history table Oracle 12c Release 2 By: petar97 on Sun, 28 October 2018	7	5192	Sun, 28 October 2018 14:57 By: Michel Cadot
How to tune Query on Large Oracle Table By: sacharya2017 on Thu, 25 October 2018	9	5112	Fri, 26 October 2018 12:51 By: sacharya2017
Generate Random Id's of existing Id's 12.2 By: lott42_gmail on Thu, 25 October 2018	14	6573	Fri, 26 October 2018 12:13 By: lott42_gmail
Replace strings [merged by jd] Oracle RDBMS, 12.1, Windows By: unna on Fri, 26 October 2018	9	5795	Fri, 26 October 2018 10:47 By: Michel Cadot
execute immediate (merged) By: mail_valeria on Fri, 26 October 2018	20	9472	Fri, 26 October 2018 08:53 By: cookiemonster
Cast to index by table By: purnima1 on Fri, 21 September 2018	4	5143	Thu, 25 October 2018 13:04 By: Barbara Boehmer
query performance EBS R12, db-10.1.1.2 By: annu-agi on Wed, 19 September 2018	9	7110	Wed, 24 October 2018 00:25 By: Michel Cadot
PLS-00201: identifier 'CTX_DDL' must be declared By: Sania Fatimi on Tue, 23 October 2018	4	8101	Tue, 23 October 2018 22:23 By: Barbara Boehmer
a procedure with dinamic sql By: jasminzeni on Wed, 17 October 2018	4	6437	Tue, 23 October 2018 07:33 By: Bill B
Written Assignment (+ example code) ( 1 2) By: cwilliam912 on Wed, 17 October 2018	51	22819	Mon, 22 October 2018 08:46 By: Barbara Boehmer
STORE SQL PROCEDURES PL/sql By: glprobot on Fri, 19 October 2018	8	5708	Fri, 19 October 2018 08:46 By: cookiemonster
Run dbms_scheduler.create_job with arguments Oracle 11.2.0.1.0 By: dansrnt on Fri, 13 May 2016	26	11847	Thu, 18 October 2018 13:43 By: Bill B
Written Assignment-Printing a Record Using an If Statement By: cwilliam912 on Sun, 14 October 2018	25	14559	Thu, 18 October 2018 04:02 By: cookiemonster
SQL Query to be grouped based on Column values By: sober_sandy on Wed, 17 October 2018	1	3563	Wed, 17 October 2018 04:39 By: Michel Cadot
Count of Pending, Failed, Running, Completed records Oracle 12c By: user_5678 on Mon, 15 October 2018	8	6128	Wed, 17 October 2018 00:39 By: user_5678
Pulling hair out trying to use table function Oracle 11 By: jbarker36 on Fri, 12 October 2018	16	10485	Tue, 16 October 2018 13:44 By: JPBoileau
DR Failure By: msyogi on Tue, 16 October 2018	6	4862	Tue, 16 October 2018 08:58 By: joy_division
Recursive query By: zhaoquer on Tue, 16 October 2018	8	6723	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	5923	Mon, 15 October 2018 14:33 By: Bill B
Convert Date in String field (merged) By: ssmith001 on Tue, 18 September 2018	21	10357	Mon, 15 October 2018 14:09 By: Bill B
Help with bitmap join indexes 11g By: Paul Newman on Mon, 08 October 2018	2	3945	Mon, 15 October 2018 10:39 By: Bill B
Duplicating Excel COUPNCD function in PLSQL. By: SATHISHENU on Tue, 04 September 2018	9	7529	Sun, 14 October 2018 12:48 By: Barbara Boehmer
Calculate problem , help me By: zhaoquer on Sat, 13 October 2018	11	5166	Sat, 13 October 2018 04:01 By: zhaoquer
Complex SQL Quiries for me 11g,12c By: graphe on Fri, 12 October 2018	6	5726	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	9060	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	4212	Wed, 10 October 2018 15:53 By: John Watson
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	3799	Tue, 09 October 2018 16:42 By: BlackSwan
Help required on assigning value to Tabletype variable! By: ramya29p on Tue, 09 October 2018	5	4422	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	3302	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	4444	Mon, 08 October 2018 04:28 By: sanjeev.sharda
How to read correctly the execution plan in oracle, both in tree and tabular mode? By: TheMatrix on Thu, 04 October 2018	6	4137	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	3682	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	3653	Thu, 04 October 2018 06:54 By: wtolentino
Creating a function Oracle 11g By: Odigitrium on Sat, 22 September 2018	6	4770	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	11360	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	4705	Sat, 29 September 2018 15:52 By: Littlefoot
Query for Matching Record --> as much matches By: myclassic on Thu, 27 September 2018	12	5159	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	7173	Thu, 27 September 2018 11:27 By: ssmith001
Create collection of nested table By: purnima1 on Wed, 26 September 2018	8	5626	Wed, 26 September 2018 09:21 By: purnima1
In Class with sub query By: nagaraju.ch on Tue, 25 September 2018	3	4275	Wed, 26 September 2018 09:09 By: Roachcoach