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
  What is the difference between MINUS and LEFT outer join
Oracle 10g, Windows
By: nathb on Fri, 27 July 2012
10 21451 Wed, 24 May 2023 08:06
By: Solomon Yakobson
  check all the distinct value match
oracle 10g windows
By: guddu_12 on Wed, 17 May 2023
9 12422 Thu, 18 May 2023 08:06
By: Michel Cadot
  Wrap Triggers
Oracle 19c
By: sinpeak on Tue, 16 May 2023
2 9724 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 9619 Mon, 15 May 2023 07:02
By: ashnamalik
  reading all values of json table
Oracle 19c
By: sss111ind on Wed, 10 May 2023
2 13708 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 20833 Tue, 09 May 2023 02:58
By: pointers
  Join purchases to customers
19c
By: Unclefool on Mon, 01 May 2023
4 6270 Mon, 01 May 2023 13:41
By: Barbara Boehmer
  Group By (merged)
19C
By: deepakdot on Thu, 27 April 2023
4 11889 Thu, 27 April 2023 23:54
By: deepakdot
  How can I speed this query up?
By: DevMuch on Thu, 27 April 2023
2 8977 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 18978 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 12161 Sat, 22 April 2023 06:18
By: Solomon Yakobson
  SQL Query help
Oracle 12c, Linux
By: rajivn786 on Sun, 16 April 2023
2 17199 Mon, 17 April 2023 15:56
By: Solomon Yakobson
  Format Dollar and Date Fields
By: _rachel_ on Wed, 12 April 2023
4 10380 Thu, 13 April 2023 04:42
By: Littlefoot
  sql query
19c
By: ora9a on Wed, 29 March 2023
10 17717 Wed, 12 April 2023 13:18
By: mathguy
  Subtrair valores
Oracle SQL Developer
By: FlaSouza on Mon, 10 April 2023
2 8296 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 12305 Sat, 08 April 2023 23:19
By: Barbara Boehmer
  Design issue
11.2.0.3.0
By: Amine on Fri, 07 April 2023
3 12035 Sat, 08 April 2023 17:50
By: mathguy
  difficult task
10g
By: urmas19 on Wed, 05 April 2023
7 6143 Wed, 05 April 2023 16:52
By: Barbara Boehmer
  Sequence alternate
19C
By: deepakdot on Tue, 28 March 2023
9 14754 Wed, 29 March 2023 07:49
By: Michel Cadot
  sql
oracle 10g
By: arun888 on Fri, 24 March 2023
2 16090 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 22223 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 15809 Thu, 23 March 2023 14:11
By: mathguy
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 9774 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 21707 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 20490 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 13278 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 50015 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 15581 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 11333 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 19561 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 25257 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 20870 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 4666 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 17927 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 23387 Fri, 17 February 2023 20:00
By: Duane
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 10632 Thu, 09 February 2023 08:30
By: Joy83
  Convert Date formats
By: deahayes on Wed, 08 February 2023
4 5345 Wed, 08 February 2023 20:47
By: Barbara Boehmer
  XML parse
19c
By: mape on Fri, 03 February 2023
20 19842 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 6403 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 20226 Tue, 31 January 2023 23:02
By: OraFerro
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 Feb 22 05:06:22 CST 2024