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
Replace column Value 12c By: deepakdot on Thu, 30 June 2022	8	12306	Fri, 01 July 2022 08:59 By: deepakdot
SENDGRID \| Curl Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: vippysharma on Thu, 16 December 2021	10	21752	Thu, 30 June 2022 04:36 By: thiyagarajancs
BASIC SYNTAX / Dynamic Pivot Table (merged) PL SQL By: Dhoback on Tue, 28 June 2022	20	17451	Thu, 30 June 2022 00:24 By: Michel Cadot
How to update multiple rows with different values from another table in the same query? Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: a_naq on Thu, 23 June 2022	4	8813	Thu, 23 June 2022 10:46 By: a_naq
Display average as part of result 19.2 By: Unclefool on Thu, 23 June 2022	2	8315	Thu, 23 June 2022 06:51 By: Unclefool
orapki: add crt and key to wallet Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0, Redhat Linux 6 By: fixxxer on Wed, 22 June 2022	6	8770	Wed, 22 June 2022 13:33 By: John Watson
Decode used in conjunction with sign Oracle 19c By: Solomon Yakobson on Fri, 10 June 2022	4	11930	Sat, 11 June 2022 18:16 By: kkaschke
Directory Name with UTL_FILE.FOPEN() Oracle, 12.2, Unix By: Duane on Fri, 03 June 2022	19	9935	Wed, 08 June 2022 13:36 By: Duane
List of partitions 12c By: azeem87 on Tue, 07 June 2022	6	4945	Wed, 08 June 2022 11:20 By: Solomon Yakobson
file transfer mechanism (FTP/SFTP/SSHFTP) using purely PL/SQL Oracle 19c database By: vaibhav8080 on Mon, 06 June 2022	6	5282	Mon, 06 June 2022 13:03 By: vaibhav8080
ORA-02270 on FK creation attempt Oracle 19c R2 Standard Edition 2 Linux By: Andrey_R on Sun, 05 June 2022	6	5302	Mon, 06 June 2022 04:47 By: Andrey_R
Trigger created with compilation errors (invalid specification trigger) SQL plus By: Syaz on Thu, 02 June 2022	2	4699	Fri, 03 June 2022 00:46 By: Michel Cadot
Previous Date value calculation through LAG function Oracle 12C By: akssre on Wed, 01 June 2022	1	5897	Thu, 02 June 2022 00:33 By: akssre
Group by department name, employee 19.2 By: Unclefool on Wed, 01 June 2022	3	5200	Wed, 01 June 2022 05:35 By: Unclefool
Can we use WHEN OTHERS exception as first Oracle 11g By: rkhatiwala on Fri, 27 May 2022	2	9398	Mon, 30 May 2022 03:52 By: Littlefoot
Help me for a SQL query Oracle HCM Fusion By: hamihai on Sun, 22 May 2022	3	5717	Sun, 22 May 2022 13:20 By: hamihai
Oracle flinding max plan id 19.8 By: Unclefool on Tue, 10 May 2022	1	15219	Wed, 11 May 2022 00:24 By: Michel Cadot
partition non partioned table 12 c By: varunvir on Wed, 27 April 2022	10	15489	Thu, 28 April 2022 14:15 By: varunvir
INSERT, SELECT CONNECT by 19.8 By: Unclefool on Tue, 26 April 2022	3	10455	Tue, 26 April 2022 14:45 By: Michel Cadot
Remove unwanted characters 19c By: varunvir on Mon, 25 April 2022	4	10598	Tue, 26 April 2022 11:51 By: varunvir
Query to create data instead of storing it 12.1.0.1.0 By: OraFerro on Mon, 25 April 2022	1	8810	Tue, 26 April 2022 05:31 By: OraFerro
How to append a header on the top of the CSV file Oracle Database 19c Enterprise Edition Release 19.0.0.0.0, Windows 10 Pro By: buggleboy007 on Thu, 21 April 2022	2	12098	Sat, 23 April 2022 08:16 By: buggleboy007
Is there a better way to do this in Oracle - Generate series with other entries Oracle >= 11.2 By: dragam on Thu, 14 April 2022	1	6612	Thu, 14 April 2022 09:05 By: Michel Cadot
question on solution provided oracle 19c(19.0.0.0.0) By: manoj12 on Wed, 13 April 2022	0	7495	Wed, 13 April 2022 20:35 By: manoj12
Help Needed in Oracle Referenced Column DataType oracle 19c By: born2achieve on Mon, 11 April 2022	3	7794	Tue, 12 April 2022 09:27 By: EdStevens
Oracle JOIN tables Oracle 19.2 By: Unclefool on Mon, 11 April 2022	4	5470	Mon, 11 April 2022 14:35 By: Unclefool
Find Difference between 2 columns along with difference data Oracle 12g By: abhayman on Thu, 31 March 2022	6	10933	Mon, 04 April 2022 02:04 By: piripicchio
XML Generation Oracle 11g, XP By: rajiv.oradev on Thu, 17 March 2022	13	21552	Sat, 02 April 2022 14:21 By: Solomon Yakobson
Data not sorted Oracle 19.2 By: Unclefool on Fri, 01 April 2022	2	9450	Fri, 01 April 2022 07:35 By: Unclefool
Oracle Update to get data from other tables using join By: benoitS on Fri, 01 April 2022	2	9123	Fri, 01 April 2022 07:10 By: Solomon Yakobson
Remove empty tags from XML Oracle 11g, XP By: rajiv.oradev on Thu, 31 March 2022	0	8058	Thu, 31 March 2022 15:33 By: rajiv.oradev
ORA-01722 Invalid Number for numeric values. Oracle 12c By: Dhritman on Fri, 25 March 2022	9	10364	Fri, 25 March 2022 05:28 By: Solomon Yakobson
DB last date 12.1.0.1.0 By: OraFerro on Wed, 23 March 2022	4	10753	Thu, 24 March 2022 07:34 By: EdStevens
Code not waiting for REFCURSOR Oracle 12c By: IanC on Thu, 17 March 2022	5	12400	Tue, 22 March 2022 05:50 By: IanC
Select Query suggestion Oracle 12c By: akssre on Tue, 15 March 2022	9	11215	Thu, 17 March 2022 05:22 By: Solomon Yakobson
Pass a "Cursor XXXX is" statement to another procedure Oracle, 12.2, Unix By: Duane on Mon, 14 March 2022	3	7955	Tue, 15 March 2022 17:56 By: Solomon Yakobson
Oracle calculate hours between timestamps 19.2 By: Unclefool on Thu, 10 March 2022	3	8820	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	13355	Wed, 09 March 2022 15:01 By: Amine
Help Needed in Date Variable By: born2achieve on Mon, 21 February 2022	1	11791	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	10425	Mon, 21 February 2022 07:16 By: gopalMisra