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 31388 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 316414 Sun, 29 January 2023 19:35
By: mathguy
  Dad, Grand Pa and Great Grand Pa !
11.2.0.3
By: Amine on Fri, 09 December 2022
6 36086 Mon, 06 February 2023 04:34
By: Amine
  XML parse
19c
By: mape on Fri, 03 February 2023
5 8590 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 16969 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 16012 Tue, 31 January 2023 23:02
By: OraFerro
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 17443 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 9279 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 10813 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 11056 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 14120 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 18164 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 13754 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 11581 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 14739 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 15413 Sun, 01 January 2023 07:57
By: Solomon Yakobson
  Parent/Child Table Design Help
Oracle, 12.2.0.1.0, Linux
By: Duane on Tue, 20 December 2022
1 22133 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 40114 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 35803 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 33328 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 32619 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 20751 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 22000 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 18337 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 12789 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 9298 Tue, 15 November 2022 09:39
By: hissam78
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
1 5918 Tue, 15 November 2022 01:11
By: John Watson
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 10109 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 6826 Thu, 10 November 2022 17:01
By: Solomon Yakobson
  JOIN with cte
By: Unclefool on Tue, 08 November 2022
1 4489 Wed, 09 November 2022 01:25
By: Michel Cadot
  Pivot query
19c
By: glmjoy on Mon, 07 November 2022
3 4377 Tue, 08 November 2022 12:42
By: glmjoy
  INSERT SELECT not working
By: Unclefool on Tue, 01 November 2022
6 8914 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 8111 Mon, 24 October 2022 04:57
By: fixxxer
  bulk date update add months (merged)
pl/sql
By: rhnshk on Thu, 20 October 2022
1 7809 Fri, 21 October 2022 14:31
By: Solomon Yakobson
icon5.gif Dynamic Source Table & Target Table
By: aimy on Tue, 11 October 2022
7 6409 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 5254 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 4011 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 11102 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 9428 Mon, 03 October 2022 08:08
By: wtolentino
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 5744 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: Mon Feb 06 07:49:58 CST 2023