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
Hex Value to Base64 Value Convertion SQL PL/SQL By: Khader Hussain on Mon, 24 January 2022	2	5986	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	7182	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	11491	Wed, 19 January 2022 06:28 By: Unclefool
Unexpected Grants To Public By: Gogetter on Wed, 12 January 2022	3	15916	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	18371	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	17049	Fri, 07 January 2022 06:36 By: Frank
Query Performance Orcale 12-c By: RGFJ on Thu, 06 January 2022	3	15867	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	26043	Wed, 05 January 2022 07:33 By: Frank
Oracle porting a natural join 19.2 By: Unclefool on Sun, 26 December 2021	2	15719	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	16097	Fri, 24 December 2021 08:10 By: Solomon Yakobson
Split a row into multiple rows Oracle By: syam09 on Thu, 23 December 2021	1	11977	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	15189	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	11973	Mon, 20 December 2021 03:32 By: vippysharma
UTL_FILE Oracle 19c By: rajivn786 on Fri, 17 December 2021	7	11684	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	7594	Thu, 09 December 2021 09:50 By: wtolentino
Using Procedure Update Date day -1 oracle sql By: Rap19 on Tue, 07 December 2021	3	7042	Thu, 09 December 2021 09:00 By: EdStevens
Oracle Display parent, child, grandchild hierarchy 19.2 By: Unclefool on Sat, 04 December 2021	4	8288	Sun, 05 December 2021 11:05 By: Unclefool
to_date in where clause By: shahzad-ul-hasan on Fri, 26 November 2021	15	15810	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	10030	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	7478	Tue, 23 November 2021 11:32 By: Solomon Yakobson
Data history 11.2.0.3 By: Amine on Thu, 04 November 2021	20	21678	Tue, 09 November 2021 18:14 By: Solomon Yakobson
Dates integrity 11.2.0.3 By: Amine on Mon, 08 November 2021	4	20464	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	18409	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	8080	Thu, 04 November 2021 13:49 By: EdStevens
Days Query 11G By: glmjoy on Wed, 27 October 2021	4	9526	Thu, 04 November 2021 11:23 By: Michel Cadot
How to get monthly average sum By: Lim on Mon, 01 November 2021	15	10082	Tue, 02 November 2021 04:27 By: Michel Cadot
Oracle stored procedure with complex conditions By: sud_oracle on Sun, 31 October 2021	4	5896	Mon, 01 November 2021 10:25 By: sud_oracle
Parsing query Oracle 11g By: akull on Mon, 01 November 2021	2	4062	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	16524	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	6693	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	22532	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	9683	Fri, 29 October 2021 00:43 By: Michel Cadot
transpose rows into columns oracle By: suji6281 on Thu, 30 September 2021	37	30148	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	5571	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	12717	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	5115	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	13973	Mon, 18 October 2021 03:12 By: saipradyumn
Select Query suggestion Oracle 12c By: akssre on Sun, 17 October 2021	5	9717	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	11070	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	11281	Wed, 06 October 2021 23:28 By: MaaM