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 31356 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 316313 Sun, 29 January 2023 19:35
By: mathguy
  XML parse
19c
By: mape on Fri, 03 February 2023
5 2769 Sat, 04 February 2023 04:53
By: mape
  Help need in writing query to get JSON format output
Oracle 19c
By: pr76666 on Mon, 30 January 2023
9 12067 Fri, 03 February 2023 09:00
By: Michel Cadot
  Duplicate rows by generating date based on column value
12.1.0.1.0
By: OraFerro on Mon, 30 January 2023
18 11830 Tue, 31 January 2023 23:02
By: OraFerro
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 14971 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 6863 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 9040 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 11028 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 14094 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 18131 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 13729 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 11561 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 14715 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 15389 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 35017 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 22114 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 40089 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 35780 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 33303 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 32580 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 20725 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 21974 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 18305 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 12763 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 9278 Tue, 15 November 2022 09:39
By: hissam78
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
1 5896 Tue, 15 November 2022 01:11
By: John Watson
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 10084 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 6809 Thu, 10 November 2022 17:01
By: Solomon Yakobson
  JOIN with cte
By: Unclefool on Tue, 08 November 2022
1 4474 Wed, 09 November 2022 01:25
By: Michel Cadot
  Pivot query
19c
By: glmjoy on Mon, 07 November 2022
3 4361 Tue, 08 November 2022 12:42
By: glmjoy
  INSERT SELECT not working
By: Unclefool on Tue, 01 November 2022
6 8897 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 8094 Mon, 24 October 2022 04:57
By: fixxxer
  bulk date update add months (merged)
pl/sql
By: rhnshk on Thu, 20 October 2022
1 7793 Fri, 21 October 2022 14:31
By: Solomon Yakobson
icon5.gif Dynamic Source Table & Target Table
By: aimy on Tue, 11 October 2022
7 6390 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 5233 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 3992 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 11085 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 9410 Mon, 03 October 2022 08:08
By: wtolentino
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 5724 Sat, 01 October 2022 09:55
By: rajivn786
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 Feb 04 05:37:08 CST 2023