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 27490 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
46 294671 Thu, 21 April 2022 01:05
By: khawja_bilalahmed
  Replace column Value
12c
By: deepakdot on Thu, 30 June 2022
1 37 Thu, 30 June 2022 11:56
By: Michel Cadot
  SENDGRID | Curl
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: vippysharma on Thu, 16 December 2021
10 13319 Thu, 30 June 2022 04:36
By: thiyagarajancs
  Min and Max values of contiguous rows (3 merged)
oracle 10g
By: arun888 on Wed, 29 June 2022
5 778 Thu, 30 June 2022 02:33
By: Michel Cadot
  BASIC SYNTAX / Dynamic Pivot Table (merged)
PL SQL
By: Dhoback on Tue, 28 June 2022
20 2069 Thu, 30 June 2022 00:24
By: Michel Cadot
aide pour un exercice has been moved to French by the moderator.
  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 6467 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 6632 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 5799 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 9856 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 5553 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 5018 Wed, 08 June 2022 13:36
By: Duane
  List of partitions
12c
By: azeem87 on Tue, 07 June 2022
6 2973 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 3286 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 3247 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 3045 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 4761 Thu, 02 June 2022 00:33
By: akssre
  Group by department name, employee
19.2
By: Unclefool on Wed, 01 June 2022
3 3647 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 7774 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 4216 Sun, 22 May 2022 13:20
By: hamihai
  Oracle flinding max plan id
19.8
By: Unclefool on Tue, 10 May 2022
1 14041 Wed, 11 May 2022 00:24
By: Michel Cadot
  partition non partioned table
12 c
By: varunvir on Wed, 27 April 2022
10 13065 Thu, 28 April 2022 14:15
By: varunvir
  INSERT, SELECT CONNECT by
19.8
By: Unclefool on Tue, 26 April 2022
3 9273 Tue, 26 April 2022 14:45
By: Michel Cadot
  Remove unwanted characters
19c
By: varunvir on Mon, 25 April 2022
4 9487 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 7982 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 11095 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 5695 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 6522 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 6837 Tue, 12 April 2022 09:27
By: EdStevens
  Oracle JOIN tables
Oracle 19.2
By: Unclefool on Mon, 11 April 2022
4 4520 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 9539 Mon, 04 April 2022 02:04
By: piripicchio
  XML Generation
Oracle 11g, XP
By: rajiv.oradev on Thu, 17 March 2022
13 19565 Sat, 02 April 2022 14:21
By: Solomon Yakobson
  Data not sorted
Oracle 19.2
By: Unclefool on Fri, 01 April 2022
2 8594 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 8306 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 7544 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 8811 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 9962 Thu, 24 March 2022 07:34
By: EdStevens
  Code not waiting for REFCURSOR
Oracle 12c
By: IanC on Thu, 17 March 2022
5 11299 Tue, 22 March 2022 05:50
By: IanC
  Select Query suggestion
Oracle 12c
By: akssre on Tue, 15 March 2022
9 9974 Thu, 17 March 2022 05:22
By: Solomon Yakobson
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: Thu Jun 30 12:33:14 CDT 2022