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 30261 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
46 306566 Thu, 21 April 2022 01:05
By: khawja_bilalahmed
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
10 9592 Fri, 02 December 2022 07:21
By: Solomon Yakobson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
4 5807 Fri, 02 December 2022 03:07
By: Michel Cadot
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
1 1006 Thu, 01 December 2022 08:07
By: Michel Cadot
  Find row count after update
Oracle 12c, Linux
By: rajiv.oradev on Fri, 18 November 2022
11 16779 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 10665 Mon, 21 November 2022 05:57
By: deepakdot
  Row into Column and sum two columns
Oracle 10 G, Windows
By: hissam78 on Tue, 15 November 2022
0 8805 Tue, 15 November 2022 09:39
By: hissam78
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
1 5371 Tue, 15 November 2022 01:11
By: John Watson
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 9286 Mon, 14 November 2022 11:48
By: lott42_gmail
  Dynamic Procedure To Drop A Database Link
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 09 November 2022
6 5860 Thu, 10 November 2022 17:01
By: Solomon Yakobson
  JOIN with cte
By: Unclefool on Tue, 08 November 2022
1 3909 Wed, 09 November 2022 01:25
By: Michel Cadot
  Pivot query
19c
By: glmjoy on Mon, 07 November 2022
3 3550 Tue, 08 November 2022 12:42
By: glmjoy
  INSERT SELECT not working
By: Unclefool on Tue, 01 November 2022
6 7771 Wed, 02 November 2022 04:19
By: John Watson
  ORA-29005: The certificate is invalid
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0
By: fixxxer on Mon, 24 October 2022
0 7423 Mon, 24 October 2022 04:57
By: fixxxer
  bulk date update add months (merged)
pl/sql
By: rhnshk on Thu, 20 October 2022
1 7089 Fri, 21 October 2022 14:31
By: Solomon Yakobson
icon5.gif Dynamic Source Table & Target Table
By: aimy on Tue, 11 October 2022
7 5483 Sat, 15 October 2022 11:56
By: aimy
  Fine Grain Access Policy
Oracle, 12.2.0.1.0, Linux
By: Duane on Wed, 12 October 2022
2 4553 Thu, 13 October 2022 20:01
By: Duane
  xml generate from db on redaction column
Oracle 12 C 2
By: sss111ind on Wed, 12 October 2022
2 3344 Wed, 12 October 2022 04:36
By: sss111ind
  Need a trigger or similar thing
Oracle Database version 19.12.0.0.0
By: Only-Oracle on Mon, 26 September 2022
5 10309 Fri, 07 October 2022 22:42
By: Only-Oracle
  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 8589 Mon, 03 October 2022 08:08
By: wtolentino
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 5144 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 7025 Fri, 30 September 2022 16:17
By: Duane
  ANSI JOIN requirement
By: nishant1987 on Fri, 30 September 2022
1 4392 Fri, 30 September 2022 09:13
By: Michel Cadot
  Sql is causing performance issue
By: nishant1987 on Tue, 27 September 2022
1 3306 Wed, 28 September 2022 01:15
By: John Watson
  INDEX hint
DB 19.3
By: John Watson on Mon, 26 September 2022
2 3112 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 8204 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 13621 Thu, 22 September 2022 04:34
By: Michel Cadot
  XMLTABLE - Multiple children
By: questvba on Tue, 19 July 2022
15 13107 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 11559 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 12294 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 5421 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 7158 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 7439 Thu, 08 September 2022 02:51
By: Michel Cadot
  PIPE ROW
Oracle, 12.2, Unix
By: Duane on Thu, 04 August 2022
7 17705 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 17414 Tue, 16 August 2022 08:51
By: Michel Cadot
  trigger not update the column
19c
By: mape on Mon, 18 July 2022
4 9375 Fri, 12 August 2022 08:35
By: Frank
  Audit Database Problem
By: Mooza on Wed, 03 August 2022
1 9754 Wed, 03 August 2022 10:38
By: Michel Cadot
  Create comma delimited function
19.2
By: Unclefool on Wed, 27 July 2022
5 11253 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 9995 Wed, 27 July 2022 12:21
By: John Watson
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: Fri Dec 02 12:51:48 CST 2022