Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
1 27386 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
46 294254 Thu, 21 April 2022 01:05
By: khawja_bilalahmed
  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 2238 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 2743 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 3675 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 9738 Sat, 11 June 2022 18:16
By: kkaschke
  Sporadic Certification Validation Error While accessing the external portal
Oracle Database 12c Release 12.1.0.2 - 64bit Production, AIX 7.2
By: jesuisantony on Fri, 10 June 2022
3 5495 Fri, 10 June 2022 12:10
By: Michel Cadot
  Directory Name with UTL_FILE.FOPEN()
Oracle, 12.2, Unix
By: Duane on Fri, 03 June 2022
19 4810 Wed, 08 June 2022 13:36
By: Duane
  List of partitions
12c
By: azeem87 on Tue, 07 June 2022
6 2909 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 3197 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 3173 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 2970 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 4700 Thu, 02 June 2022 00:33
By: akssre
  Group by department name, employee
19.2
By: Unclefool on Wed, 01 June 2022
3 3561 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 7651 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 4136 Sun, 22 May 2022 13:20
By: hamihai
  Oracle flinding max plan id
19.8
By: Unclefool on Tue, 10 May 2022
1 14001 Wed, 11 May 2022 00:24
By: Michel Cadot
  partition non partioned table
12 c
By: varunvir on Wed, 27 April 2022
10 12993 Thu, 28 April 2022 14:15
By: varunvir
  INSERT, SELECT CONNECT by
19.8
By: Unclefool on Tue, 26 April 2022
3 9238 Tue, 26 April 2022 14:45
By: Michel Cadot
  Remove unwanted characters
19c
By: varunvir on Mon, 25 April 2022
4 9453 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 7952 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 11065 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 5659 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 6487 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 6800 Tue, 12 April 2022 09:27
By: EdStevens
  Oracle JOIN tables
Oracle 19.2
By: Unclefool on Mon, 11 April 2022
4 4488 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 9479 Mon, 04 April 2022 02:04
By: piripicchio
  XML Generation
Oracle 11g, XP
By: rajiv.oradev on Thu, 17 March 2022
13 19511 Sat, 02 April 2022 14:21
By: Solomon Yakobson
  Data not sorted
Oracle 19.2
By: Unclefool on Fri, 01 April 2022
2 8555 Fri, 01 April 2022 07:35
By: Unclefool
icon9.gif Oracle Update to get data from other tables using join
By: benoitS on Fri, 01 April 2022
2 8266 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 7508 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 8776 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 9925 Thu, 24 March 2022 07:34
By: EdStevens
  Code not waiting for REFCURSOR
Oracle 12c
By: IanC on Thu, 17 March 2022
5 11262 Tue, 22 March 2022 05:50
By: IanC
  Select Query suggestion
Oracle 12c
By: akssre on Tue, 15 March 2022
9 9935 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 7203 Tue, 15 March 2022 17:56
By: Solomon Yakobson
  Oracle calculate hours between timestamps
19.2
By: Unclefool on Thu, 10 March 2022
3 7866 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 12355 Wed, 09 March 2022 15:01
By: Amine
  Help Needed in Date Variable
By: born2achieve on Mon, 21 February 2022
1 11254 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 8647 Mon, 21 February 2022 07:16
By: gopalMisra
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Sat Jun 25 14:13:24 CDT 2022