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 update the nested array in json clob column data using plsql..? By: jeevetha on Thu, 23 December 2021	2	15217	Fri, 24 December 2021 08:10 By: Solomon Yakobson
Split a row into multiple rows Oracle By: syam09 on Thu, 23 December 2021	1	11300	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	14279	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	10658	Mon, 20 December 2021 03:32 By: vippysharma
UTL_FILE Oracle 19c By: rajivn786 on Fri, 17 December 2021	7	10861	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	6693	Thu, 09 December 2021 09:50 By: wtolentino
Using Procedure Update Date day -1 oracle sql By: Rap19 on Tue, 07 December 2021	3	6255	Thu, 09 December 2021 09:00 By: EdStevens
Oracle Display parent, child, grandchild hierarchy 19.2 By: Unclefool on Sat, 04 December 2021	4	6780	Sun, 05 December 2021 11:05 By: Unclefool
to_date in where clause By: shahzad-ul-hasan on Fri, 26 November 2021	15	14693	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	9167	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	6412	Tue, 23 November 2021 11:32 By: Solomon Yakobson
Data history 11.2.0.3 By: Amine on Thu, 04 November 2021	20	20525	Tue, 09 November 2021 18:14 By: Solomon Yakobson
Dates integrity 11.2.0.3 By: Amine on Mon, 08 November 2021	4	19803	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	17843	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	7409	Thu, 04 November 2021 13:49 By: EdStevens
Days Query 11G By: glmjoy on Wed, 27 October 2021	4	8884	Thu, 04 November 2021 11:23 By: Michel Cadot
How to get monthly average sum By: Lim on Mon, 01 November 2021	15	8843	Tue, 02 November 2021 04:27 By: Michel Cadot
Oracle stored procedure with complex conditions By: sud_oracle on Sun, 31 October 2021	4	4964	Mon, 01 November 2021 10:25 By: sud_oracle
Parsing query Oracle 11g By: akull on Mon, 01 November 2021	2	3483	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	15525	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	6098	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	21184	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	8532	Fri, 29 October 2021 00:43 By: Michel Cadot
transpose rows into columns oracle By: suji6281 on Thu, 30 September 2021	37	28543	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	4798	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	11767	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	4510	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	12950	Mon, 18 October 2021 03:12 By: saipradyumn
Select Query suggestion Oracle 12c By: akssre on Sun, 17 October 2021	5	9106	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	10060	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	10280	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	5577	Mon, 04 October 2021 06:27 By: vippysharma
SQL Query- Connect By (merged) 11g By: sayan13 on Tue, 28 September 2021	3	9100	Tue, 28 September 2021 01:28 By: Michel Cadot
Extract string between 2 text 11gr2 By: guddu_12 on Sun, 26 September 2021	6	9379	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	4271	Tue, 21 September 2021 20:12 By: EdStevens
member and collection type oracle 12.1 By: pointers on Wed, 08 September 2021	4	13581	Sat, 11 September 2021 01:57 By: pointers
Slab Level query (merged) Oracle 11 By: annu-agi on Mon, 06 September 2021	6	13230	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	9227	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	9848	Sat, 04 September 2021 13:46 By: glmjoy
Write an SQL query to report the students (student_id, student_name) being “quiet” in ALL exams. A “ By: vritik on Fri, 03 September 2021	1	7448	Fri, 03 September 2021 11:54 By: Michel Cadot