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 33340 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 322875 Sun, 29 January 2023 19:35
By: mathguy
  What is the difference between MINUS and LEFT outer join
Oracle 10g, Windows
By: nathb on Fri, 27 July 2012
10 17949 Wed, 24 May 2023 08:06
By: Solomon Yakobson
sqlldr has been moved to Server Utilities by the moderator.
  check all the distinct value match
oracle 10g windows
By: guddu_12 on Wed, 17 May 2023
9 10427 Thu, 18 May 2023 08:06
By: Michel Cadot
  Wrap Triggers
Oracle 19c
By: sinpeak on Tue, 16 May 2023
2 8188 Tue, 16 May 2023 16:51
By: mbobak
  How to get count of records that do not have more than 1 specific value in 1 column
PL-SQL
By: Linhardt on Mon, 01 May 2023
8 7481 Mon, 15 May 2023 07:02
By: ashnamalik
  reading all values of json table
Oracle 19c
By: sss111ind on Wed, 10 May 2023
2 12097 Wed, 10 May 2023 09:52
By: Barbara Boehmer
  elapsed time for a id
Oracle 12.1
By: pointers on Wed, 03 May 2023
5 19017 Tue, 09 May 2023 02:58
By: pointers
  Join purchases to customers
19c
By: Unclefool on Mon, 01 May 2023
4 4728 Mon, 01 May 2023 13:41
By: Barbara Boehmer
  Group By (merged)
19C
By: deepakdot on Thu, 27 April 2023
4 10397 Thu, 27 April 2023 23:54
By: deepakdot
  How can I speed this query up?
By: DevMuch on Thu, 27 April 2023
2 7600 Thu, 27 April 2023 15:11
By: DevMuch
  LOB Locator
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0, CentOS release 6.7
By: fixxxer on Wed, 19 April 2023
5 17265 Tue, 25 April 2023 03:11
By: fixxxer
  Custom password verify function
Oracle DB 12c,19c, Exadata RHEL 7.9
By: Nagesh1985 on Thu, 20 April 2023
7 9707 Sat, 22 April 2023 06:18
By: Solomon Yakobson
  SQL Query help
Oracle 12c, Linux
By: rajivn786 on Sun, 16 April 2023
2 15829 Mon, 17 April 2023 15:56
By: Solomon Yakobson
  Format Dollar and Date Fields
By: _rachel_ on Wed, 12 April 2023
4 8888 Thu, 13 April 2023 04:42
By: Littlefoot
  sql query
19c
By: ora9a on Wed, 29 March 2023
10 16057 Wed, 12 April 2023 13:18
By: mathguy
  Subtrair valores
Oracle SQL Developer
By: FlaSouza on Mon, 10 April 2023
2 6666 Mon, 10 April 2023 11:23
By: Barbara Boehmer
  Oracle Style with Table Alias
Oracle, 12.2.0.1.0, Linux
By: Duane on Fri, 07 April 2023
5 10745 Sat, 08 April 2023 23:19
By: Barbara Boehmer
  Design issue
11.2.0.3.0
By: Amine on Fri, 07 April 2023
3 10728 Sat, 08 April 2023 17:50
By: mathguy
  difficult task
10g
By: urmas19 on Wed, 05 April 2023
7 4648 Wed, 05 April 2023 16:52
By: Barbara Boehmer
  Sequence alternate
19C
By: deepakdot on Tue, 28 March 2023
9 13304 Wed, 29 March 2023 07:49
By: Michel Cadot
  sql
oracle 10g
By: arun888 on Fri, 24 March 2023
2 14680 Fri, 24 March 2023 09:29
By: arun888
  Min and Max values of contiguous rows (3 merged)
oracle 10g
By: arun888 on Wed, 29 June 2022
11 20824 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 14590 Thu, 23 March 2023 14:11
By: mathguy
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 8659 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 20201 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 19245 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 12095 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 47381 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 14685 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 8280 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 12487 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 23562 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 19297 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 3765 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 16987 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 22337 Fri, 17 February 2023 20:00
By: Duane
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 9524 Thu, 09 February 2023 08:30
By: Joy83
  Convert Date formats
By: deahayes on Wed, 08 February 2023
4 4328 Wed, 08 February 2023 20:47
By: Barbara Boehmer
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 Jun 07 00:37:06 CDT 2023