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
icon5.gif How create such attached table by travelling view and its dependent objects
Oracle 18c
By: mm_kanish05 on Thu, 22 June 2023
6 15654 Sat, 24 June 2023 13:19
By: Barbara Boehmer
  Oracle function to get account balance
19c
By: Unclefool on Fri, 23 June 2023
2 13051 Fri, 23 June 2023 11:30
By: Michel Cadot
  Letter and TIMESTAMP CONCAT (INSERT error)
19c
By: Unclefool on Sat, 17 June 2023
4 8830 Sat, 17 June 2023 10:31
By: Unclefool
  Query to split date count into multiple rows and level that over weeks .
By: itzkashi on Wed, 14 June 2023
2 14701 Thu, 15 June 2023 09:45
By: itzkashi
  What is the difference between MINUS and LEFT outer join
Oracle 10g, Windows
By: nathb on Fri, 27 July 2012
10 21635 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 12480 Thu, 18 May 2023 08:06
By: Michel Cadot
  Wrap Triggers
Oracle 19c
By: sinpeak on Tue, 16 May 2023
2 9789 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 9705 Mon, 15 May 2023 07:02
By: ashnamalik
  reading all values of json table
Oracle 19c
By: sss111ind on Wed, 10 May 2023
2 13761 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 20932 Tue, 09 May 2023 02:58
By: pointers
  Join purchases to customers
19c
By: Unclefool on Mon, 01 May 2023
4 6362 Mon, 01 May 2023 13:41
By: Barbara Boehmer
  Group By (merged)
19C
By: deepakdot on Thu, 27 April 2023
4 11952 Thu, 27 April 2023 23:54
By: deepakdot
  How can I speed this query up?
By: DevMuch on Thu, 27 April 2023
2 9038 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 19039 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 12328 Sat, 22 April 2023 06:18
By: Solomon Yakobson
  SQL Query help
Oracle 12c, Linux
By: rajivn786 on Sun, 16 April 2023
2 17255 Mon, 17 April 2023 15:56
By: Solomon Yakobson
  Format Dollar and Date Fields
By: _rachel_ on Wed, 12 April 2023
4 10437 Thu, 13 April 2023 04:42
By: Littlefoot
  sql query
19c
By: ora9a on Wed, 29 March 2023
10 17769 Wed, 12 April 2023 13:18
By: mathguy
  Subtrair valores
Oracle SQL Developer
By: FlaSouza on Mon, 10 April 2023
2 8374 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 12349 Sat, 08 April 2023 23:19
By: Barbara Boehmer
  Design issue
11.2.0.3.0
By: Amine on Fri, 07 April 2023
3 12067 Sat, 08 April 2023 17:50
By: mathguy
  difficult task
10g
By: urmas19 on Wed, 05 April 2023
7 6192 Wed, 05 April 2023 16:52
By: Barbara Boehmer
  Sequence alternate
19C
By: deepakdot on Tue, 28 March 2023
9 14800 Wed, 29 March 2023 07:49
By: Michel Cadot
  sql
oracle 10g
By: arun888 on Fri, 24 March 2023
2 16152 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 22261 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 15856 Thu, 23 March 2023 14:11
By: mathguy
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 9814 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 21773 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 20530 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 13319 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 50196 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 15631 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 11617 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 19631 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 25296 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 20930 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 4700 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 17963 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 23457 Fri, 17 February 2023 20:00
By: Duane
  Difference between two dates
By: Joy83 on Thu, 09 February 2023
4 10675 Thu, 09 February 2023 08:30
By: Joy83
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: Tue Mar 19 02:13:35 CDT 2024