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
Query to group data Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 By: fixxxer on Fri, 31 August 2018	14	9897	Fri, 31 August 2018 11:36 By: Solomon Yakobson
Oracle regular expressions query Oracle 11.2.0.2.0 By: jackman1 on Thu, 23 August 2018	2	4358	Thu, 23 August 2018 12:57 By: jackman1
SQLException encounter while executing data trigger. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vharish006 on Mon, 20 August 2018	4	9165	Thu, 23 August 2018 11:55 By: cookiemonster
find circular reference in data By: purnima1 on Thu, 23 August 2018	4	4608	Thu, 23 August 2018 06:55 By: Solomon Yakobson
consistency constraint ON store Procedure 12c, window By: Bilal Khan on Tue, 21 August 2018	22	10586	Tue, 21 August 2018 08:52 By: Solomon Yakobson
Running settlement of inward vs outward quantity Oracle 11g By: chintan.patel on Mon, 20 August 2018	13	7834	Tue, 21 August 2018 08:02 By: quirks
Relation between two gold By: purnima1 on Tue, 21 August 2018	3	4779	Tue, 21 August 2018 07:15 By: Michel Cadot
Joining multiple rows and creating multiple columns By: purnima1 on Mon, 20 August 2018	9	5659	Tue, 21 August 2018 07:13 By: Michel Cadot
Strange Issue in executing procedure Oracle 11g By: manikandan23 on Wed, 15 August 2018	22	11669	Mon, 20 August 2018 10:01 By: JPBoileau
Row Movement disabled in Partitioned table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sun, 19 August 2018	5	6891	Mon, 20 August 2018 06:30 By: Roachcoach
Prevent Rounding when using Format Masking Oracle 12.1.0.2.0, RHEL By: abhi_orcl on Thu, 16 August 2018	6	8656	Fri, 17 August 2018 18:37 By: Solomon Yakobson
Extracting just text from a Blob Column 11.2 By: dejah on Thu, 16 August 2018	5	6192	Fri, 17 August 2018 18:28 By: Solomon Yakobson
SQL to Subtract X workdays from a date Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: ssmith001 on Wed, 15 August 2018	32	16009	Fri, 17 August 2018 07:53 By: Michel Cadot
FIND MONTHS 11.2.0.4.0 By: megha25 on Thu, 16 August 2018	11	6901	Fri, 17 August 2018 07:53 By: Bill B
Teradata To Oracle MOD Function By: kawi6rr on Thu, 16 August 2018	2	4240	Fri, 17 August 2018 03:30 By: cookiemonster
Put data from one field to another. PLSQL By: twardybidon on Thu, 16 August 2018	5	5261	Thu, 16 August 2018 10:34 By: Michel Cadot
failing in Creation of PL/SQL function PL SQL ORACLE By: bench on Wed, 15 August 2018	14	9661	Thu, 16 August 2018 07:44 By: Bill B
Last 7 days report oracle 11g By: akash123 on Wed, 15 August 2018	5	5290	Wed, 15 August 2018 06:24 By: akash123
XML Special Character Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: vharish006 on Tue, 14 August 2018	0	4586	Tue, 14 August 2018 15:07 By: vharish006
Split Data in Column & Split Data in Excel (merged) Excel 2016 By: vharish006 on Mon, 13 August 2018	7	5480	Mon, 13 August 2018 13:53 By: vharish006
How to Convert Row to Column As Below Oracle 11g By: sonudev on Mon, 13 August 2018	11	6541	Mon, 13 August 2018 08:11 By: joy_division
Dbms_metadat 12c By: Kannan Oracle on Fri, 10 August 2018	2	4685	Fri, 10 August 2018 07:42 By: joy_division
Spool Japanese Characters Oracle 11g By: pratyush_biswas on Thu, 09 August 2018	4	8145	Fri, 10 August 2018 07:05 By: Bill B
PL/SQL Collection Oracle 11G By: RaShi.Raj on Thu, 09 August 2018	4	5187	Thu, 09 August 2018 06:43 By: poojagarg
Get Record Count Oracle 11g By: lokimisc on Mon, 06 August 2018	9	9057	Thu, 09 August 2018 04:19 By: pablolee
Back fill records Oracle 11.2.0.3 By: pointers on Wed, 08 August 2018	4	4923	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	11371	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	4936	Mon, 30 July 2018 08:31 By: raresn
Performance of Stored Programs Oracle 12c , Linux By: ninan on Sun, 29 July 2018	14	8198	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	7345	Sun, 29 July 2018 09:23 By: greenwaldliron
Possibility of Name Oracle 11G By: Genesys on Mon, 16 July 2018	7	9700	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	10603	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	5730	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	8314	Mon, 23 July 2018 11:10 By: Michel Cadot
Oracle materialized views workflow By: camillelola on Fri, 20 July 2018	3	5929	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	9885	Fri, 20 July 2018 04:16 By: elmomagalona
Get last record from another table 11g By: ritaman on Mon, 16 July 2018	17	10552	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	8967	Tue, 17 July 2018 12:19 By: Lalit Kumar B
query performance 11g By: annu-agi on Sat, 14 July 2018	3	6452	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	6517	Tue, 17 July 2018 06:26 By: ajaychinna