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
how to display the values with prefix increment? Oracle By: ramanajak on Thu, 28 May 2020	3	4339	Thu, 28 May 2020 09:24 By: Michel Cadot
UTL_MAIL vs UTL_SMTP sending CLOB body 11.2.0.1.0 By: OraFerro on Wed, 13 May 2020	13	9438	Wed, 27 May 2020 16:53 By: Bill B
Audit Database Problem By: nisauaz on Wed, 27 May 2020	1	4259	Wed, 27 May 2020 12:24 By: Michel Cadot
materialized view issue oracle 11.2.0.3 By: irashu2001@gmail.com on Tue, 19 May 2020	7	8716	Wed, 27 May 2020 07:08 By: Bill B
Return names of bind variables Version 9.0.4.1644 01.75108 Windows (64-bit) 6.2 Build 9200 By: nbs on Sat, 23 May 2020	6	8864	Tue, 26 May 2020 02:50 By: nbs
Missing number in series of numbers Oracle 11g, windows By: Vijay55 on Wed, 18 May 2016	6	10733	Mon, 25 May 2020 07:19 By: Solomon Yakobson
key with different values By: desmond30 on Sat, 23 May 2020	3	5989	Sun, 24 May 2020 06:22 By: Solomon Yakobson
Using associated array as SP parameter 12.2 By: thegerman on Thu, 21 May 2020	6	6414	Fri, 22 May 2020 06:30 By: Solomon Yakobson
JSON Column for A Single Element with Potentially Multiple Values? Oracle 19c By: bmccollum on Thu, 21 May 2020	1	4070	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	3842	Thu, 21 May 2020 05:46 By: Michel Cadot
driving_site hint DB12.x By: John Watson on Tue, 19 May 2020	20	7734	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	19298	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	3313	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	6268	Mon, 18 May 2020 04:58 By: Lalit Kumar B
Procedure creation help By: chavva.kiru@gmail.com on Wed, 13 May 2020	8	4515	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	3528	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	2567	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	7631	Tue, 12 May 2020 08:17 By: Michel Cadot
Date Column By: deepakdot on Wed, 06 May 2020	25	6785	Sat, 09 May 2020 13:31 By: Michel Cadot
Configuring Scripts Windows 7 By: Premananda on Sun, 26 April 2020	6	4334	Sat, 09 May 2020 12:33 By: EdStevens
Looping Chain of Synonyms Oracle Database 12 By: mushy.khan1985 on Wed, 06 May 2020	14	6129	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	3927	Wed, 06 May 2020 12:21 By: Michel Cadot
Limit error on function PL/SQL By: ram43 on Mon, 04 May 2020	3	3533	Tue, 05 May 2020 01:24 By: _jum
PL/SQL problem Oracle SQL developer By: nedislav on Fri, 01 May 2020	11	7086	Fri, 01 May 2020 12:29 By: EdStevens
drithsx By: glyph on Fri, 01 May 2020	2	3602	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	9316	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	6225	Tue, 28 April 2020 14:28 By: wtolentino
Query 12.0.2 By: bha_96 on Sat, 25 April 2020	22	11710	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	3493	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	4119	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	7676	Wed, 22 April 2020 10:26 By: WillJ
Emp Code Searching Issue Oracle DB 12C By: wasimK on Tue, 21 April 2020	6	3466	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	3295	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	1978	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	4064	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	2647	Mon, 20 April 2020 08:42 By: Amine
Text to number conversion Oracle SQL Developer By: dorustd on Tue, 10 March 2020	15	10726	Sat, 18 April 2020 07:14 By: Jamesconnor
Function call in ref cursor Oracle 11gR2 By: Bhushan.Mahajan on Tue, 14 April 2020	7	5160	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	7910	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	5036	Wed, 15 April 2020 07:21 By: Michel Cadot