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
JSON Column for A Single Element with Potentially Multiple Values? Oracle 19c By: bmccollum on Thu, 21 May 2020	1	5679	Thu, 21 May 2020 17:33 By: Solomon Yakobson
The cost of FILTER operations DB 19.x By: John Watson on Thu, 21 May 2020	1	5511	Thu, 21 May 2020 05:46 By: Michel Cadot
driving_site hint DB12.x By: John Watson on Tue, 19 May 2020	20	12524	Wed, 20 May 2020 15:53 By: Lalit Kumar B
ORA-21561: OID generation failed !! Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Redhat 6 By: fixxxer on Wed, 07 March 2018	12	22992	Wed, 20 May 2020 08:06 By: fixxxer
Using SELECT to display various totals 12.2.0.2 By: johnw66 on Mon, 18 May 2020	4	4634	Tue, 19 May 2020 00:08 By: Michel Cadot
Transposing data in single row Oracle 12 c By: OracleDBA_beginner on Fri, 15 May 2020	11	9084	Mon, 18 May 2020 04:58 By: Lalit Kumar B
Procedure creation help By: chavva.kiru@gmail.com on Wed, 13 May 2020	8	6514	Thu, 14 May 2020 10:55 By: Michel Cadot
Creation of new partitions by increasing the sequence number oracle 12C By: chavva.kiru@gmail.com on Wed, 13 May 2020	5	5010	Wed, 13 May 2020 23:32 By: chavva.kiru@gmail.com
Stored Procedure - not able to display no data found message By: subash_141 on Wed, 13 May 2020	2	3643	Wed, 13 May 2020 07:13 By: Solomon Yakobson
Displaying select results in double columns 11.2.0.1.0 By: OraFerro on Sat, 09 May 2020	25	10708	Tue, 12 May 2020 08:17 By: Michel Cadot
Date Column By: deepakdot on Wed, 06 May 2020	25	9374	Sat, 09 May 2020 13:31 By: Michel Cadot
Configuring Scripts Windows 7 By: Premananda on Sun, 26 April 2020	6	5633	Sat, 09 May 2020 12:33 By: EdStevens
Looping Chain of Synonyms Oracle Database 12 By: mushy.khan1985 on Wed, 06 May 2020	14	9612	Wed, 06 May 2020 14:21 By: mushy.khan1985
Query needs to be tune 12.2.0.2 By: bha_96 on Wed, 06 May 2020	4	5405	Wed, 06 May 2020 12:21 By: Michel Cadot
Limit error on function PL/SQL By: ram43 on Mon, 04 May 2020	3	4792	Tue, 05 May 2020 01:24 By: _jum
PL/SQL problem Oracle SQL developer By: nedislav on Fri, 01 May 2020	11	10570	Fri, 01 May 2020 12:29 By: EdStevens
drithsx By: glyph on Fri, 01 May 2020	2	4839	Fri, 01 May 2020 08:19 By: Michel Cadot
ORA-04042 issue when trying to grant the access Oracle By: raghuguru on Mon, 27 April 2020	11	14809	Wed, 29 April 2020 08:02 By: EdStevens
"ORA-00942: table or view does not exist" when creating view via role's privilege Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Thu, 23 April 2020	5	8510	Tue, 28 April 2020 14:28 By: wtolentino
Query 12.0.2 By: bha_96 on Sat, 25 April 2020	22	17260	Mon, 27 April 2020 03:16 By: Michel Cadot
How too convert rows into columns based on order hiredate month wise oracle 12c By: narendraenamala on Fri, 24 April 2020	1	4379	Fri, 24 April 2020 00:57 By: Michel Cadot
Need age difference between warning and critical Oracle By: soubalaji on Wed, 22 April 2020	9	6487	Wed, 22 April 2020 12:10 By: Michel Cadot
Duplicate returns from list of Values Oracle APEX By: WillJ on Fri, 17 April 2020	20	11443	Wed, 22 April 2020 10:26 By: WillJ
Emp Code Searching Issue Oracle DB 12C By: wasimK on Tue, 21 April 2020	6	4836	Tue, 21 April 2020 11:52 By: Michel Cadot
Extracting specific portion of a string using REGEX Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professiona By: buggleboy007 on Mon, 06 April 2020	3	4454	Mon, 20 April 2020 17:31 By: buggleboy007
PL/SQL Stored Procedure Showing Oracle Error 27476 (Job Doesn't Exist) Oracle 12c By: bmccollum on Mon, 20 April 2020	2	2866	Mon, 20 April 2020 14:43 By: bmccollum
RAISE_APPLICATION_ERROR not invoked by Logon trigger Oracle 11.2.0.3.0 SE , Oracle 12.1.0.2.0 SE By: Andrey_R on Sun, 19 April 2020	10	6527	Mon, 20 April 2020 11:28 By: Michel Cadot
Hierarchy again and again 11.2.0.3.0 By: Amine on Sun, 19 April 2020	5	3517	Mon, 20 April 2020 08:42 By: Amine
Text to number conversion Oracle SQL Developer By: dorustd on Tue, 10 March 2020	15	14125	Sat, 18 April 2020 07:14 By: Jamesconnor
Function call in ref cursor Oracle 11gR2 By: Bhushan.Mahajan on Tue, 14 April 2020	7	6778	Wed, 15 April 2020 10:07 By: Michel Cadot
Create Materialized View throws "ORA-01031: insufficient privileges" Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Tue, 14 April 2020	2	14554	Wed, 15 April 2020 07:23 By: Michel Cadot
Fine Grain Access control disabled but still prevents to create Materialized View Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Tue, 14 April 2020	6	6772	Wed, 15 April 2020 07:21 By: Michel Cadot
Calculating the Difference of Timestamp in Min, Sec Windows 2012, 11g, 12c By: Giles02 on Mon, 13 April 2020	9	6402	Tue, 14 April 2020 07:45 By: Michel Cadot
create materialized view log with explicit constraint (merged) Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Mon, 13 April 2020	3	4012	Mon, 13 April 2020 14:16 By: wtolentino
Filtering result from 2 PL/SQL UNION queries PL/SQL 9.0 By: gbuck on Thu, 09 April 2020	1	5000	Thu, 09 April 2020 15:45 By: Michel Cadot
Subquery returns more than one row - where clause -decode oracle 12c By: New50 on Wed, 08 April 2020	11	9596	Thu, 09 April 2020 14:40 By: Michel Cadot
Adding a from () to a query made it so slow 11.2.0.1.0 By: OraFerro on Mon, 06 April 2020	6	6026	Wed, 08 April 2020 08:13 By: OraFerro
getting finacial week number oracle 11gr2 By: guddu_12 on Thu, 17 April 2014	15	15701	Sun, 05 April 2020 11:16 By: danielarias
How To Add Full Email Body Text from File to CLOB Column? Oracle 12c By: bmccollum on Wed, 01 April 2020	1	5048	Thu, 02 April 2020 00:11 By: Michel Cadot
Fill in records where date missing in sequence Oracle 12c, Querying with SQL Developer v3.2.20.10 By: sqlafterdark on Tue, 31 March 2020	1	4322	Tue, 31 March 2020 23:43 By: Michel Cadot