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 31315 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 312466 Sun, 29 January 2023 19:35
By: mathguy
  Duplicate rows by generating date based on column value
12.1.0.1.0
By: OraFerro on Mon, 30 January 2023
17 2315 Tue, 31 January 2023 14:08
By: mathguy
  Help need in writing query to get JSON format output
Oracle 19c
By: pr76666 on Mon, 30 January 2023
2 704 Tue, 31 January 2023 01:06
By: Michel Cadot
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 9804 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 2310 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 4488 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 7278 Mon, 30 January 2023 00:30
By: ibrahimzuberi
  greatest total amount of purchases per day for each customer_id
By: Unclefool on Sat, 14 January 2023
3 14070 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 18087 Mon, 16 January 2023 10:59
By: Duane
  Base64 to Blob
Oracle, 12.2.0.1.0, Linux
By: Duane on Thu, 12 January 2023
2 13701 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 11543 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 14686 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 15357 Sun, 01 January 2023 07:57
By: Solomon Yakobson
  Dad, Grand Pa and Great Grand Pa !
11.2.0.3
By: Amine on Fri, 09 December 2022
2 34992 Wed, 21 December 2022 07:54
By: _jum
  Parent/Child Table Design Help
Oracle, 12.2.0.1.0, Linux
By: Duane on Tue, 20 December 2022
1 22096 Wed, 21 December 2022 01:17
By: John Watson
  Months Calculation and update Statement
Oracle 11G, Windows
By: hissam78 on Sat, 10 December 2022
5 40067 Sun, 11 December 2022 13:02
By: Michel Cadot
  String Extract using REGEXP_SUBSTR
Oracle, 12.2.0.1.0, Linux
By: Duane on Fri, 09 December 2022
6 35755 Sat, 10 December 2022 15:05
By: Solomon Yakobson
  Update difference between two dates in months
Oracle 11 G, Windows
By: hissam78 on Wed, 07 December 2022
3 33275 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 32544 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 20696 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 21947 Sat, 03 December 2022 00:37
By: Michel Cadot
  Find row count after update
Oracle 12c, Linux
By: rajiv.oradev on Fri, 18 November 2022
11 18270 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 12730 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 9258 Tue, 15 November 2022 09:39
By: hissam78
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
1 5875 Tue, 15 November 2022 01:11
By: John Watson
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 10067 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 6787 Thu, 10 November 2022 17:01
By: Solomon Yakobson
  JOIN with cte
By: Unclefool on Tue, 08 November 2022
1 4456 Wed, 09 November 2022 01:25
By: Michel Cadot
  Pivot query
19c
By: glmjoy on Mon, 07 November 2022
3 4328 Tue, 08 November 2022 12:42
By: glmjoy
  INSERT SELECT not working
By: Unclefool on Tue, 01 November 2022
6 8877 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 8059 Mon, 24 October 2022 04:57
By: fixxxer
  bulk date update add months (merged)
pl/sql
By: rhnshk on Thu, 20 October 2022
1 7777 Fri, 21 October 2022 14:31
By: Solomon Yakobson
icon5.gif Dynamic Source Table & Target Table
By: aimy on Tue, 11 October 2022
7 6371 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 5214 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 3970 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 11065 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 9386 Mon, 03 October 2022 08:08
By: wtolentino
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 5708 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 7820 Fri, 30 September 2022 16:17
By: Duane
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: Tue Jan 31 18:31:25 CST 2023