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 29230 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
46 303881 Thu, 21 April 2022 01:05
By: khawja_bilalahmed
  trigger executing a procedure to execute dbms_stats.gather_table_stats
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 28 September 2022
5 5100 Mon, 03 October 2022 08:08
By: wtolentino
  Need a trigger or similar thing
Oracle Database version 19.12.0.0.0
By: Only-Oracle on Mon, 26 September 2022
4 5777 Mon, 03 October 2022 01:33
By: Michel Cadot
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 3714 Sat, 01 October 2022 09:55
By: rajivn786
  Procedure Parameter List
Oracle, 12.2.0.1.0, Linux
By: Duane on Wed, 28 September 2022
7 6040 Fri, 30 September 2022 16:17
By: Duane
  ANSI JOIN requirement
By: nishant1987 on Fri, 30 September 2022
1 3684 Fri, 30 September 2022 09:13
By: Michel Cadot
  Sql is causing performance issue
By: nishant1987 on Tue, 27 September 2022
1 2705 Wed, 28 September 2022 01:15
By: John Watson
  INDEX hint
DB 19.3
By: John Watson on Mon, 26 September 2022
2 2447 Mon, 26 September 2022 08:40
By: John Watson
  Calling shell scripts from dbms_scheduler
Oracle 12.1.0.2.0, Red Hat 7.6
By: cookiemonster on Wed, 21 September 2022
15 7351 Thu, 22 September 2022 10:20
By: cookiemonster
  Min and Max values of contiguous rows (3 merged)
oracle 10g
By: arun888 on Wed, 29 June 2022
10 12755 Thu, 22 September 2022 04:34
By: Michel Cadot
  XMLTABLE - Multiple children
By: questvba on Tue, 19 July 2022
15 12271 Mon, 19 September 2022 22:20
By: ananyaa
  How to send email with OAuth (merged)
Oracle, 12.1, Enterprise Edition, Linux
By: praveenpraj on Thu, 15 September 2022
2 10859 Fri, 16 September 2022 13:35
By: Alien
  Combine 2 fields when using Groupby (merged)
Oracle DB 18c
By: halifaxns on Tue, 13 September 2022
8 11708 Wed, 14 September 2022 14:22
By: halifaxns
  Running Balance
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: shawaj on Mon, 12 September 2022
7 4891 Tue, 13 September 2022 01:31
By: shawaj
  Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
11.2.0.4.0
By: skfaheem024 on Thu, 08 September 2022
3 6610 Sat, 10 September 2022 01:11
By: skfaheem024
  Where is the session timeout value for the duration of running an sql query/procedure
By: Bob Alston on Wed, 07 September 2022
3 6935 Thu, 08 September 2022 02:51
By: Michel Cadot
  PIPE ROW
Oracle, 12.2, Unix
By: Duane on Thu, 04 August 2022
7 16948 Sat, 27 August 2022 05:22
By: Solomon Yakobson
  Retrieve last month running total when current month is null
ORACLE 11G
By: Lim on Tue, 16 August 2022
8 16637 Tue, 16 August 2022 08:51
By: Michel Cadot
  trigger not update the column
19c
By: mape on Mon, 18 July 2022
4 8736 Fri, 12 August 2022 08:35
By: Frank
  Audit Database Problem
By: Mooza on Wed, 03 August 2022
1 9174 Wed, 03 August 2022 10:38
By: Michel Cadot
  Create comma delimited function
19.2
By: Unclefool on Wed, 27 July 2022
5 10649 Thu, 28 July 2022 08:31
By: Michel Cadot
  Problem in partition exchange
Oracle 12 C 2
By: sss111ind on Wed, 27 July 2022
5 9369 Wed, 27 July 2022 12:21
By: John Watson
  Plsql function testing years
19.2
By: Unclefool on Thu, 21 July 2022
2 5666 Thu, 21 July 2022 12:42
By: Michel Cadot
  Need to derive YTD,MAT,MQT
oracle
By: samiran_cts on Wed, 20 July 2022
4 5530 Wed, 20 July 2022 11:59
By: samiran_cts
  Plsql using NVL
19.2
By: Unclefool on Tue, 19 July 2022
2 3085 Tue, 19 July 2022 15:01
By: Unclefool
  Integrity constraint violation
19.2
By: Unclefool on Wed, 13 July 2022
2 11697 Wed, 13 July 2022 01:14
By: Unclefool
  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
4 10392 Sun, 10 July 2022 03:28
By: jesuisantony
  Teachers teaching the most students
19.2
By: Unclefool on Sun, 03 July 2022
10 14408 Sun, 10 July 2022 02:43
By: Michel Cadot
  Replace column Value
12c
By: deepakdot on Thu, 30 June 2022
8 10827 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 19561 Thu, 30 June 2022 04:36
By: thiyagarajancs
  BASIC SYNTAX / Dynamic Pivot Table (merged)
PL SQL
By: Dhoback on Tue, 28 June 2022
20 13489 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 7657 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 7504 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 7156 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 11071 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 7359 Wed, 08 June 2022 13:36
By: Duane
  List of partitions
12c
By: azeem87 on Tue, 07 June 2022
6 4170 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 4521 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 4551 Mon, 06 June 2022 04:47
By: Andrey_R
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: Wed Oct 05 03:17:20 CDT 2022