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
Oracle porting a natural join 19.2 By: Unclefool on Sun, 26 December 2021	2	17574	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	18308	Fri, 24 December 2021 08:10 By: Solomon Yakobson
Split a row into multiple rows Oracle By: syam09 on Thu, 23 December 2021	1	13731	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	18813	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	14856	Mon, 20 December 2021 03:32 By: vippysharma
UTL_FILE Oracle 19c By: rajivn786 on Fri, 17 December 2021	7	14339	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	9959	Thu, 09 December 2021 09:50 By: wtolentino
Using Procedure Update Date day -1 oracle sql By: Rap19 on Tue, 07 December 2021	3	10235	Thu, 09 December 2021 09:00 By: EdStevens
Oracle Display parent, child, grandchild hierarchy 19.2 By: Unclefool on Sat, 04 December 2021	4	12034	Sun, 05 December 2021 11:05 By: Unclefool
to_date in where clause By: shahzad-ul-hasan on Fri, 26 November 2021	15	20129	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	11760	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	9632	Tue, 23 November 2021 11:32 By: Solomon Yakobson
Data history 11.2.0.3 By: Amine on Thu, 04 November 2021	20	25862	Tue, 09 November 2021 18:14 By: Solomon Yakobson
Dates integrity 11.2.0.3 By: Amine on Mon, 08 November 2021	4	22109	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	19707	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	9835	Thu, 04 November 2021 13:49 By: EdStevens
Days Query 11G By: glmjoy on Wed, 27 October 2021	4	11477	Thu, 04 November 2021 11:23 By: Michel Cadot
How to get monthly average sum By: Lim on Mon, 01 November 2021	15	14794	Tue, 02 November 2021 04:27 By: Michel Cadot
Oracle stored procedure with complex conditions By: sud_oracle on Sun, 31 October 2021	4	8635	Mon, 01 November 2021 10:25 By: sud_oracle
Parsing query Oracle 11g By: akull on Mon, 01 November 2021	2	5814	Mon, 01 November 2021 08:35 By: akull
Data Dictionary for Collection Bind variables Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: saipradyumn on Tue, 19 October 2021	9	19762	Fri, 29 October 2021 15:35 By: Andrey_R
Oracle SQL a=b and b=a Oracle 12C By: rahul1982 on Fri, 29 October 2021	3	8659	Fri, 29 October 2021 14:25 By: EdStevens
Long query with WITH not responding Ora 11.2.0.3.0 By: Reversi72 on Mon, 11 October 2021	23	30604	Fri, 29 October 2021 04:44 By: Reversi72
Unable to take backup of a table Oracle, 18.0.0.0.0, CentOS Linux release 7.8.2003 (Core) By: BalajiDBA on Thu, 28 October 2021	8	13381	Fri, 29 October 2021 00:43 By: Michel Cadot
transpose rows into columns oracle By: suji6281 on Thu, 30 September 2021	37	37105	Thu, 28 October 2021 22:03 By: Sekhar6617
How to substract 2 varchar2 dates (YYYYMMDDHH24MMSS) in oracle? By: mmm286 on Tue, 26 October 2021	5	7452	Wed, 27 October 2021 08:51 By: Andrey_R
Who call me all versions from 11g to 19c By: Michel Cadot on Fri, 22 October 2021	11	15784	Sun, 24 October 2021 03:26 By: Michel Cadot
Prefix data into an existing clob 19.2 By: Unclefool on Sat, 23 October 2021	1	6576	Sat, 23 October 2021 12:03 By: Solomon Yakobson
DBMS_JOB.SUBMIT not appearing Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: saipradyumn on Mon, 04 October 2021	6	16427	Mon, 18 October 2021 03:12 By: saipradyumn
Select Query suggestion Oracle 12c By: akssre on Sun, 17 October 2021	5	11918	Mon, 18 October 2021 00:33 By: Michel Cadot
Is there a way to create a materialized view with datatype and length? By: joy_division on Fri, 08 October 2021	7	14336	Fri, 08 October 2021 15:37 By: Solomon Yakobson
Retrieve font name available in OS using sql plus Windows 7, Oracle 10g XE By: lock_heart on Wed, 04 December 2013	16	16296	Wed, 06 October 2021 23:28 By: MaaM
REGEXP_LIKE 12c ENT Edition 12.2.0.1.0 By: vippysharma on Mon, 04 October 2021	2	7963	Mon, 04 October 2021 06:27 By: vippysharma
SQL Query- Connect By (merged) 11g By: sayan13 on Tue, 28 September 2021	3	11496	Tue, 28 September 2021 01:28 By: Michel Cadot
Extract string between 2 text 11gr2 By: guddu_12 on Sun, 26 September 2021	6	14655	Sun, 26 September 2021 10:22 By: guddu_12
Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path Oracle R12 By: kjnf505 on Mon, 20 September 2021	1	7155	Tue, 21 September 2021 20:12 By: EdStevens
member and collection type oracle 12.1 By: pointers on Wed, 08 September 2021	4	16801	Sat, 11 September 2021 01:57 By: pointers
Slab Level query (merged) Oracle 11 By: annu-agi on Mon, 06 September 2021	6	16681	Tue, 07 September 2021 03:00 By: annu-agi
Function Finding multiple occurrences of a string 19c By: Unclefool on Mon, 06 September 2021	4	12419	Mon, 06 September 2021 21:23 By: Unclefool
query to display employee whose code is 03 is not inserted 11g By: glmjoy on Sat, 04 September 2021	6	13214	Sat, 04 September 2021 13:46 By: glmjoy