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
Pass a "Cursor XXXX is" statement to another procedure Oracle, 12.2, Unix By: Duane on Mon, 14 March 2022	3	7287	Tue, 15 March 2022 17:56 By: Solomon Yakobson
Oracle calculate hours between timestamps 19.2 By: Unclefool on Thu, 10 March 2022	3	7974	Thu, 10 March 2022 17:30 By: EdStevens
Let's promote them all ! 11.2.0.3 By: Amine on Fri, 18 February 2022	8	12445	Wed, 09 March 2022 15:01 By: Amine
Help Needed in Date Variable By: born2achieve on Mon, 21 February 2022	1	11321	Tue, 22 February 2022 00:34 By: Michel Cadot
Getting ORA-24374 , when using function in with query (merged) PLSQL 12.1.0.2.0 By: gopalMisra on Tue, 15 February 2022	13	8770	Mon, 21 February 2022 07:16 By: gopalMisra
SQL -Report missing string when running a query Oracle 11 windows 10 By: Kevin1967 on Wed, 16 February 2022	4	5397	Sat, 19 February 2022 00:26 By: Michel Cadot
Facing issie in 19c By: nishant87 on Thu, 17 February 2022	5	5847	Thu, 17 February 2022 08:16 By: EdStevens
Putting a row with a particular value on top of a sort Oracle 21, Windows 10 By: orHooha on Wed, 09 February 2022	3	6953	Wed, 09 February 2022 20:59 By: orHooha
query oracle11g By: Norfree on Wed, 02 February 2022	4	12541	Tue, 08 February 2022 06:49 By: Solomon Yakobson
record count between one hour Oracle 19c By: bkbora on Fri, 04 February 2022	3	6591	Sun, 06 February 2022 06:21 By: Solomon Yakobson
Oracle case INSERT statement 19.2 By: Unclefool on Fri, 04 February 2022	6	6325	Sat, 05 February 2022 09:14 By: EdStevens
Print value in table columns dynamically By: dancko on Sun, 30 January 2022	5	15520	Wed, 02 February 2022 13:10 By: Michel Cadot
ORA-04068: existing state of packages has been discarded Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat By: fixxxer on Fri, 30 August 2019	7	12425	Wed, 02 February 2022 03:38 By: fixxxer
transpose logic oracle By: suji6281 on Tue, 25 January 2022	6	12544	Sat, 29 January 2022 18:31 By: Solomon Yakobson
ORA 00922 MISSING OR INVALID OPTION ORACLE 12C , ORACLE FORMS AND REPORTS 12C By: lacchhii on Mon, 24 January 2022	2	5713	Tue, 25 January 2022 21:50 By: lacchhii
Hex Value to Base64 Value Convertion SQL PL/SQL By: Khader Hussain on Mon, 24 January 2022	2	3268	Mon, 24 January 2022 03:30 By: Khader Hussain
Dynamically pass table name in PLSQL Oracle client 18.0 By: 345678 on Sat, 22 January 2022	6	4916	Mon, 24 January 2022 03:16 By: 345678
PL/SQL escaping variable with a single quote 19.2 By: Unclefool on Tue, 18 January 2022	2	9503	Wed, 19 January 2022 06:28 By: Unclefool
Unexpected Grants To Public By: Gogetter on Wed, 12 January 2022	3	13730	Wed, 12 January 2022 03:21 By: Gogetter
Oracle generate from-to DATE ranges and group by 19.2 By: Unclefool on Fri, 07 January 2022	2	16335	Fri, 07 January 2022 06:52 By: Unclefool
Defining Variables in the Package Spec Oracle, 12.2, Unix By: Duane on Thu, 06 January 2022	3	15120	Fri, 07 January 2022 06:36 By: Frank
Query Performance Orcale 12-c By: RGFJ on Thu, 06 January 2022	3	13683	Fri, 07 January 2022 06:34 By: Frank
Two MAX Functions in a Single SELECT Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 By: whdyck on Thu, 23 December 2021	12	22673	Wed, 05 January 2022 07:33 By: Frank
Oracle porting a natural join 19.2 By: Unclefool on Sun, 26 December 2021	2	13994	Tue, 28 December 2021 02:27 By: John Watson
How to update the nested array in json clob column data using plsql..? By: jeevetha on Thu, 23 December 2021	2	13778	Fri, 24 December 2021 08:10 By: Solomon Yakobson
Split a row into multiple rows Oracle By: syam09 on Thu, 23 December 2021	1	10432	Thu, 23 December 2021 08:08 By: Michel Cadot
Flatten table to get unique VALUES 19.2 By: Unclefool on Thu, 16 December 2021	9	12211	Mon, 20 December 2021 11:22 By: John Watson
ORA 12545 \| UTL_HTTP Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: vippysharma on Wed, 15 December 2021	4	8183	Mon, 20 December 2021 03:32 By: vippysharma
UTL_FILE Oracle 19c By: rajivn786 on Fri, 17 December 2021	7	9471	Fri, 17 December 2021 13:06 By: Michel Cadot
XMLtype throwing an error ORA-00932 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Thu, 09 December 2021	3	5123	Thu, 09 December 2021 09:50 By: wtolentino
Using Procedure Update Date day -1 oracle sql By: Rap19 on Tue, 07 December 2021	3	5245	Thu, 09 December 2021 09:00 By: EdStevens
Oracle Display parent, child, grandchild hierarchy 19.2 By: Unclefool on Sat, 04 December 2021	4	5257	Sun, 05 December 2021 11:05 By: Unclefool
to_date in where clause By: shahzad-ul-hasan on Fri, 26 November 2021	15	12671	Sun, 05 December 2021 02:19 By: OraFerro
DBA_HIST_SQLTEXT string buffer too small Oracle 12.1 By: db_senior on Sat, 27 November 2021	1	8138	Sat, 27 November 2021 04:20 By: Michel Cadot
Oracle regex_substr parsing a clob 19.2 By: Unclefool on Tue, 23 November 2021	1	5547	Tue, 23 November 2021 11:32 By: Solomon Yakobson
Data history 11.2.0.3 By: Amine on Thu, 04 November 2021	20	17914	Tue, 09 November 2021 18:14 By: Solomon Yakobson
Dates integrity 11.2.0.3 By: Amine on Mon, 08 November 2021	4	18803	Tue, 09 November 2021 03:09 By: Amine
Sequence number to be entered by a user Oracle 12c, O/S: Windows 10 pro By: buggleboy007 on Fri, 05 November 2021	2	17128	Sat, 06 November 2021 09:26 By: buggleboy007
Select value from multiple dates Oracle 10g By: shahzad-ul-hasan on Thu, 04 November 2021	4	6160	Thu, 04 November 2021 13:49 By: EdStevens
Days Query 11G By: glmjoy on Wed, 27 October 2021	4	7859	Thu, 04 November 2021 11:23 By: Michel Cadot