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
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 10690 Thu, 09 February 2023 08:30
By: Joy83
  Convert Date formats
By: deahayes on Wed, 08 February 2023
4 5407 Wed, 08 February 2023 20:47
By: Barbara Boehmer
  XML parse
19c
By: mape on Fri, 03 February 2023
20 19970 Wed, 08 February 2023 13:04
By: Barbara Boehmer
  Loop and save the index in an incremental number array
By: Joy83 on Mon, 06 February 2023
8 6465 Mon, 06 February 2023 21:15
By: Joy83
  Duplicate rows by generating date based on column value
12.1.0.1.0
By: OraFerro on Mon, 30 January 2023
18 20277 Tue, 31 January 2023 23:02
By: OraFerro
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 19851 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 12212 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 12663 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 13157 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 16237 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 21050 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 16876 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 13336 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 16521 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 17358 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 23895 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 42283 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 38007 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 35518 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 35925 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 23451 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 24594 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 21448 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 15977 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 11591 Tue, 15 November 2022 09:39
By: hissam78
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 12632 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 9338 Thu, 10 November 2022 17:01
By: Solomon Yakobson
  JOIN with cte
By: Unclefool on Tue, 08 November 2022
1 6178 Wed, 09 November 2022 01:25
By: Michel Cadot
  Pivot query
19c
By: glmjoy on Mon, 07 November 2022
3 6083 Tue, 08 November 2022 12:42
By: glmjoy
  INSERT SELECT not working
By: Unclefool on Tue, 01 November 2022
6 10860 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 10725 Mon, 24 October 2022 04:57
By: fixxxer
  bulk date update add months (merged)
pl/sql
By: rhnshk on Thu, 20 October 2022
1 10014 Fri, 21 October 2022 14:31
By: Solomon Yakobson
icon5.gif Dynamic Source Table & Target Table
By: aimy on Tue, 11 October 2022
7 8873 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 7717 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 6336 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 13396 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 11840 Mon, 03 October 2022 08:08
By: wtolentino
  Columns replicate
Oracle 12c
By: rajivn786 on Fri, 30 September 2022
2 7616 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 10230 Fri, 30 September 2022 16:17
By: Duane
  ANSI JOIN requirement
By: nishant1987 on Fri, 30 September 2022
1 6031 Fri, 30 September 2022 09:13
By: Michel Cadot
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: Thu Mar 28 10:47:13 CDT 2024