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
PL/SQL Collection Oracle 11G By: RaShi.Raj on Thu, 09 August 2018	4	5690	Thu, 09 August 2018 06:43 By: poojagarg
Get Record Count Oracle 11g By: lokimisc on Mon, 06 August 2018	9	9780	Thu, 09 August 2018 04:19 By: pablolee
Back fill records Oracle 11.2.0.3 By: pointers on Wed, 08 August 2018	4	5444	Wed, 08 August 2018 14:26 By: Solomon Yakobson
Create JSON from SQL 12C R1 By: Manoj.Gupta.91 on Mon, 30 July 2018	10	12173	Tue, 31 July 2018 12:36 By: Solomon Yakobson
OR clause degrades performance of a query? Oracle database, any, Linux By: raresn on Mon, 30 July 2018	2	5395	Mon, 30 July 2018 08:31 By: raresn
Performance of Stored Programs Oracle 12c , Linux By: ninan on Sun, 29 July 2018	14	8991	Mon, 30 July 2018 03:02 By: Michel Cadot
return top 10 records based on dynamic count of prev records results oracle 11 By: greenwaldliron on Sun, 29 July 2018	7	7933	Sun, 29 July 2018 09:23 By: greenwaldliron
Possibility of Name Oracle 11G By: Genesys on Mon, 16 July 2018	7	10306	Fri, 27 July 2018 20:13 By: Barbara Boehmer
How to ensure uniqueness on RAISE_APPLICATION_ERROR By: ramya29p on Mon, 23 July 2018	14	11371	Thu, 26 July 2018 03:27 By: cookiemonster
passing date value to the query from sql*plus By: shrinika on Mon, 23 July 2018	3	6197	Tue, 24 July 2018 12:08 By: shrinika
PL/SQL: ORA-04053: error occurred when validating remote object oracle12c By: shrinika on Thu, 11 May 2017	3	8883	Mon, 23 July 2018 11:10 By: Michel Cadot
Oracle materialized views workflow By: camillelola on Fri, 20 July 2018	3	6459	Fri, 20 July 2018 13:19 By: Lalit Kumar B
ORA-04091: table Table_Name is mutating, trigger/function may not see it Oracle 11g With Apex 5.1 By: Mukul Ahmed on Fri, 13 July 2018	7	10528	Fri, 20 July 2018 04:16 By: elmomagalona
Get last record from another table 11g By: ritaman on Mon, 16 July 2018	17	11342	Wed, 18 July 2018 05:26 By: cookiemonster
Need Help on Pl/Sql Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vharish006 on Tue, 17 July 2018	11	9794	Tue, 17 July 2018 12:19 By: Lalit Kumar B
query performance 11g By: annu-agi on Sat, 14 July 2018	3	6952	Tue, 17 July 2018 06:29 By: Bill B
how to work around the substitution variables in plsql Oracle 12c By: mgag on Mon, 02 July 2018	3	6971	Tue, 17 July 2018 06:26 By: ajaychinna
Generate New Excel format (XLSX) files using Oracle PLSQL Oracle 11.2.0.4 By: nickz on Fri, 13 July 2018	3	16326	Mon, 16 July 2018 06:52 By: Bill B
Need Help on Creating FUNCTION By: vharish006 on Tue, 10 July 2018	13	9668	Wed, 11 July 2018 03:43 By: cookiemonster
SELECT QUERY Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vharish006 on Tue, 10 July 2018	6	7045	Wed, 11 July 2018 03:38 By: flyboy
rownum from table By: suji6281 on Mon, 09 July 2018	7	7262	Tue, 10 July 2018 06:06 By: Bill B
How can bulk insert into the parent , child tables Oracle Linux 6.7, Oracle 12.1.0.2.0 By: fabi88 on Sun, 08 July 2018	10	11321	Tue, 10 July 2018 05:30 By: fabi88
Report query Oracle 12CR2 By: srinivas.k2005 on Wed, 04 July 2018	10	9054	Mon, 09 July 2018 12:38 By: joy_division
type of constraints By: diana365 on Wed, 16 January 2002	4	6130	Mon, 09 July 2018 07:41 By: Bill B
problem with concatenation and group by functions 11g By: achraf87 on Wed, 04 July 2018	11	8902	Thu, 05 July 2018 07:51 By: achraf87
Stored Procedure / Deletion Conflict Oracle 12C By: dba_vijay on Tue, 03 July 2018	13	8232	Thu, 05 July 2018 03:40 By: cookiemonster
Help required on ranking logic By: ramya29p on Mon, 02 July 2018	6	6359	Tue, 03 July 2018 23:11 By: ramya29p
How to get decimal value from string and convert 11g By: tikun on Thu, 28 June 2018	18	11716	Tue, 03 July 2018 06:19 By: Bill B
Extract domain name from email address field PS/SQL By: heidibb on Tue, 29 November 2011	19	31906	Tue, 03 July 2018 06:15 By: Bill B
Select using DBMS_SQL.EXECUTE (merged) Oracle Linux 6.7, Oracle 12.1.0.2.0 By: fabi88 on Mon, 02 July 2018	6	7907	Mon, 02 July 2018 04:07 By: Michel Cadot
Alter Table <<table name>> add partition by range does not work Oracle 11g By: manikandan23 on Thu, 28 June 2018	4	7930	Fri, 29 June 2018 06:52 By: Bill B
How to replace the new line and line feed in a specific manner oracle 11g By: POGAKU_SANTHOSH on Wed, 20 June 2018	5	9265	Thu, 28 June 2018 01:43 By: POGAKU_SANTHOSH
Fetching Unix Folder Name and Timestamp in SQL/PLSQL Oracle 11.2.0.4 By: nickz on Fri, 08 June 2018	26	18456	Mon, 25 June 2018 14:05 By: nickz
Difference between two dates By: desmond30 on Tue, 19 June 2018	9	7463	Mon, 25 June 2018 06:48 By: Bill B
Compare current and previous record Oracle 10 g By: Danny Freeman on Fri, 15 June 2018	13	11638	Wed, 20 June 2018 11:50 By: Bill B
SQL: Substring folder name based on numeric value Oracle DB 11.2.0.4 By: nickz on Thu, 14 June 2018	11	9867	Wed, 20 June 2018 02:06 By: nickz
Help Grouping by By: akull on Mon, 18 June 2018	6	5812	Mon, 18 June 2018 11:33 By: akull
divide text string into different columns By: suji6281 on Mon, 28 May 2018	10	9020	Mon, 18 June 2018 10:33 By: suji6281
problem of inserting a long string of characters :ORA-22835: Taille de tampon insuffisante pour la c 11g By: achraf87 on Mon, 18 June 2018	2	6539	Mon, 18 June 2018 08:53 By: cookiemonster
Use multi-threading in PL/SQL Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: Manoj.Gupta.91 on Mon, 18 June 2018	1	11478	Mon, 18 June 2018 07:53 By: BlackSwan