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
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 10157 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 22099 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 20867 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 13635 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 50703 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 15894 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 12734 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 19941 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 25566 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 21223 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 4969 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 18233 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 23754 Fri, 17 February 2023 20:00
By: Duane
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 10977 Thu, 09 February 2023 08:30
By: Joy83
  Convert Date formats
By: deahayes on Wed, 08 February 2023
4 5707 Wed, 08 February 2023 20:47
By: Barbara Boehmer
  XML parse
19c
By: mape on Fri, 03 February 2023
20 20383 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 6772 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 20580 Tue, 31 January 2023 23:02
By: OraFerro
  xml auto generate atribute
19c
By: mape on Wed, 18 January 2023
5 20164 Tue, 31 January 2023 00:27
By: mathguy
  Get customer with GREATEST amount of purchases
By: Unclefool on Sun, 29 January 2023
12 12515 Mon, 30 January 2023 09:55
By: mathguy
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
3 12962 Mon, 30 January 2023 07:26
By: rxelgin
  Two Column Join
Oracle PL SQL
By: ibrahimzuberi on Fri, 27 January 2023
9 13490 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 16535 Tue, 17 January 2023 02:11
By: Michel Cadot
  SQL very slow
EBS R12.2.8
By: ccpCCP88 on Tue, 10 January 2023
16 21398 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 17361 Thu, 12 January 2023 15:20
By: Duane
  Row Level trigger
By: indupriyav_2023 on Wed, 11 January 2023
1 13624 Wed, 11 January 2023 04:09
By: Michel Cadot
  COALESCE and CASE
By: questvba on Tue, 03 January 2023
5 16808 Wed, 04 January 2023 07:57
By: Michel Cadot
  xml error eurofxref-daily.xml
19c
By: mape on Sun, 01 January 2023
7 17634 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 24176 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 42577 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 38295 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 35793 Fri, 09 December 2022 18:10
By: hissam78
  Value multiple
Sql Plus, Oracle 10G, Windows
By: hissam78 on Fri, 25 November 2022
14 36239 Wed, 07 December 2022 17:02
By: hissam78
  Performance issue with Update statement having select Statement
By: VVR on Thu, 01 December 2022
4 23747 Tue, 06 December 2022 01:00
By: John Watson
  Function not working
Oracle 10G, Windows
By: hissam78 on Tue, 29 November 2022
6 24908 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 21787 Wed, 23 November 2022 18:47
By: rajiv.oradev
  unique timestamp
By: deepakdot on Tue, 15 November 2022
8 16302 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 11870 Tue, 15 November 2022 09:39
By: hissam78
  RegEX data parsing
12.1
By: lott42_gmail on Thu, 10 November 2022
5 12911 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 9665 Thu, 10 November 2022 17:01
By: Solomon Yakobson
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: Wed May 29 16:09:32 CDT 2024