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
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	8949	Thu, 27 September 2018 11:27 By: ssmith001
Create collection of nested table By: purnima1 on Wed, 26 September 2018	8	6986	Wed, 26 September 2018 09:21 By: purnima1
In Class with sub query By: nagaraju.ch on Tue, 25 September 2018	3	5434	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	10574	Tue, 25 September 2018 13:01 By: wtolentino
SQL code syntax Understanding By: anirdesh on Sat, 22 September 2018	3	5458	Sat, 22 September 2018 14:29 By: Solomon Yakobson
OE SAMPEL SCHEMA ORACLE 12.2.0.1.0, window 10 By: Bilal Khan on Thu, 20 September 2018	22	13866	Thu, 20 September 2018 09:48 By: BlackSwan
Help w/ REGEXP_SUBSTR By: ssmith001 on Thu, 06 September 2018	26	14202	Tue, 18 September 2018 11:02 By: ssmith001
Time difference between 2 rows oracle 12c By: azeem87 on Wed, 12 September 2018	10	7868	Tue, 18 September 2018 09:10 By: JPBoileau
Adding rownum in pagination query in oralce 12c Oracle 12c By: sss111ind on Sat, 15 September 2018	8	5886	Mon, 17 September 2018 04:00 By: Michel Cadot
Error in PL/SQL package function (table of records) 11.1.2.10 By: OraFerro on Sun, 16 September 2018	2	4745	Mon, 17 September 2018 00:23 By: OraFerro
Processed time for a Job SQL 11G By: s.m.ramachandran on Fri, 14 September 2018	5	5599	Fri, 14 September 2018 08:14 By: Solomon Yakobson
String Comparison Oracle 12.2 Windows By: Duane on Tue, 11 September 2018	9	8719	Wed, 12 September 2018 04:06 By: Michel Cadot
Help in Understanding a complex (complex at least for me) sql to solve sudoku 11.2.04 By: orausern on Sat, 08 September 2018	3	6152	Sun, 09 September 2018 09:03 By: Solomon Yakobson
update column on same table using database trigger By: mist598 on Thu, 06 September 2018	27	21521	Fri, 07 September 2018 09:25 By: Bill B
Help in YIELD [Excel Function] formula in PLSQL Oracle 11 G By: SATHISHENU on Mon, 27 November 2017	6	10067	Tue, 04 September 2018 01:14 By: Michel Cadot
Urgent : SQL Queries SQL By: akriti on Mon, 07 December 2015	13	15914	Sat, 01 September 2018 20:53 By: Barbara Boehmer
Oracle ad-hoc report issues Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional By: buggleboy007 on Wed, 29 August 2018	14	9792	Fri, 31 August 2018 11:58 By: buggleboy007
Query to group data Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 By: fixxxer on Fri, 31 August 2018	14	10518	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	4738	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	9886	Thu, 23 August 2018 11:55 By: cookiemonster
find circular reference in data By: purnima1 on Thu, 23 August 2018	4	5067	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	11623	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	8492	Tue, 21 August 2018 08:02 By: quirks
Relation between two gold By: purnima1 on Tue, 21 August 2018	3	5158	Tue, 21 August 2018 07:15 By: Michel Cadot
Joining multiple rows and creating multiple columns By: purnima1 on Mon, 20 August 2018	9	6287	Tue, 21 August 2018 07:13 By: Michel Cadot
Strange Issue in executing procedure Oracle 11g By: manikandan23 on Wed, 15 August 2018	22	12676	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	7597	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	9421	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	6642	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	17078	Fri, 17 August 2018 07:53 By: Michel Cadot
FIND MONTHS 11.2.0.4.0 By: megha25 on Thu, 16 August 2018	11	7566	Fri, 17 August 2018 07:53 By: Bill B
Teradata To Oracle MOD Function By: kawi6rr on Thu, 16 August 2018	2	4682	Fri, 17 August 2018 03:30 By: cookiemonster
Put data from one field to another. PLSQL By: twardybidon on Thu, 16 August 2018	5	5770	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	10480	Thu, 16 August 2018 07:44 By: Bill B
Last 7 days report oracle 11g By: akash123 on Wed, 15 August 2018	5	5812	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	4949	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	5957	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	7134	Mon, 13 August 2018 08:11 By: joy_division
Dbms_metadat 12c By: Kannan Oracle on Fri, 10 August 2018	2	5089	Fri, 10 August 2018 07:42 By: joy_division
Spool Japanese Characters Oracle 11g By: pratyush_biswas on Thu, 09 August 2018	4	8817	Fri, 10 August 2018 07:05 By: Bill B