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
Who deleted the data 12c By: deepakdot on Tue, 23 October 2018	21	6474	Mon, 29 October 2018 02:10 By: deepakdot
How to make a trigger on the table for the history table Oracle 12c Release 2 By: petar97 on Sun, 28 October 2018	7	1833	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	2023	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	1710	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	1383	Fri, 26 October 2018 10:47 By: Michel Cadot
execute immediate (merged) By: mail_valeria on Fri, 26 October 2018	20	3376	Fri, 26 October 2018 08:53 By: cookiemonster
Cast to index by table By: purnima1 on Fri, 21 September 2018	4	1965	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	2470	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	2262	Tue, 23 October 2018 22:23 By: Barbara Boehmer
a procedure with dinamic sql By: jasminzeni on Wed, 17 October 2018	4	2886	Tue, 23 October 2018 07:33 By: Bill B
Written Assignment (+ example code) ( 1 2) By: cwilliam912 on Wed, 17 October 2018	51	5436	Mon, 22 October 2018 08:46 By: Barbara Boehmer
STORE SQL PROCEDURES PL/sql By: glprobot on Fri, 19 October 2018	8	1973	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	4909	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	5975	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	1288	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	2426	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	2832	Tue, 16 October 2018 13:44 By: JPBoileau
DR Failure By: msyogi on Tue, 16 October 2018	6	1740	Tue, 16 October 2018 08:58 By: joy_division
Recursive query By: zhaoquer on Tue, 16 October 2018	8	1553	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	2553	Mon, 15 October 2018 14:33 By: Bill B
Convert Date in String field (merged) By: ssmith001 on Tue, 18 September 2018	21	4921	Mon, 15 October 2018 14:09 By: Bill B
Help with bitmap join indexes 11g By: Paul Newman on Mon, 08 October 2018	2	1723	Mon, 15 October 2018 10:39 By: Bill B
Duplicating Excel COUPNCD function in PLSQL. By: SATHISHENU on Tue, 04 September 2018	9	2665	Sun, 14 October 2018 12:48 By: Barbara Boehmer
Calculate problem , help me By: zhaoquer on Sat, 13 October 2018	11	1825	Sat, 13 October 2018 04:01 By: zhaoquer
Complex SQL Quiries for me 11g,12c By: graphe on Fri, 12 October 2018	6	1806	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	2447	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	1325	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	1573	Tue, 09 October 2018 16:42 By: BlackSwan
Help required on assigning value to Tabletype variable! By: ramya29p on Tue, 09 October 2018	5	1630	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	1347	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	1873	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	1823	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	1416	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	1443	Thu, 04 October 2018 06:54 By: wtolentino
Creating a function Oracle 11g By: Odigitrium on Sat, 22 September 2018	6	1836	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	4728	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	1641	Sat, 29 September 2018 15:52 By: Littlefoot
Query for Matching Record --> as much matches By: myclassic on Thu, 27 September 2018	12	1986	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	1529	Thu, 27 September 2018 11:27 By: ssmith001
Create collection of nested table By: purnima1 on Wed, 26 September 2018	8	1950	Wed, 26 September 2018 09:21 By: purnima1