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
  Min and Max values of contiguous rows (3 merged)
oracle 10g
By: arun888 on Wed, 29 June 2022
11 29119 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 21990 Thu, 23 March 2023 14:11
By: mathguy
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 13641 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 29523 Tue, 21 March 2023 07:58
By: chat2raj.s
  Rescheduling installments by distributing amounts
12.1.0.1.0
By: OraFerro on Mon, 13 March 2023
8 26829 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 22326 Mon, 13 March 2023 23:07
By: akssre
  Ternary Operator in PL/SQL
Oracle 10g on UNIX
By: soham.desai@gmail.com on Tue, 26 August 2008
3 56821 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 17924 Sun, 12 March 2023 01:30
By: mape
  Different UTC time from SYSDATE on different databases
Oracle 21c/19c
By: Andrey_R on Wed, 08 March 2023
15 32140 Thu, 09 March 2023 10:02
By: Andrey_R
  Identify Groups where 2 or more Clients have bought the same Products - SQL Oracle
SQL - ORACLE
By: Nicha on Fri, 03 March 2023
33 36415 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 33758 Mon, 06 March 2023 09:53
By: mathguy
  how to incrementally get all numbers incremented by n between 2 columns values
oracle 19c
By: avtaritet on Mon, 27 February 2023
27 34350 Mon, 06 March 2023 08:38
By: Michel Cadot
  Need Help with Table Type
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
By: vinodkumarn on Sun, 05 March 2023
2 8072 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 21429 Sat, 25 February 2023 11:19
By: Michel Cadot
  Cast(Multiset())
Oracle, 12.2.0.1.0, Linux
By: Duane on Wed, 15 February 2023
17 32750 Fri, 17 February 2023 20:00
By: Duane
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 16165 Thu, 09 February 2023 08:30
By: Joy83
  Convert Date formats
By: deahayes on Wed, 08 February 2023
4 10279 Wed, 08 February 2023 20:47
By: Barbara Boehmer
  XML parse
19c
By: mape on Fri, 03 February 2023
20 32097 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 13256 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 30026 Tue, 31 January 2023 23:02
By: OraFerro
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 24464 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 20358 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 16653 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 20712 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 20113 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 31689 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 23094 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 16299 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 21556 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 23221 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 26636 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 46409 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 42901 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 39042 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 44279 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 28194 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 29839 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 30229 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 21922 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 13618 Tue, 15 November 2022 09:39
By: hissam78
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 Nov 07 08:19:35 CST 2026