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
  DBMS LDAP package
Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Sun Solaris
By: vinayrajn on Mon, 26 June 2023
2 15456 Mon, 26 June 2023 16:13
By: vinayrajn
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 15673 Sat, 24 June 2023 13:19
By: Barbara Boehmer
  Oracle function to get account balance
19c
By: Unclefool on Fri, 23 June 2023
2 13072 Fri, 23 June 2023 11:30
By: Michel Cadot
  Letter and TIMESTAMP CONCAT (INSERT error)
19c
By: Unclefool on Sat, 17 June 2023
4 8847 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 14719 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 21689 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 12499 Thu, 18 May 2023 08:06
By: Michel Cadot
  Wrap Triggers
Oracle 19c
By: sinpeak on Tue, 16 May 2023
2 9810 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 9725 Mon, 15 May 2023 07:02
By: ashnamalik
  reading all values of json table
Oracle 19c
By: sss111ind on Wed, 10 May 2023
2 13775 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 20951 Tue, 09 May 2023 02:58
By: pointers
  Join purchases to customers
19c
By: Unclefool on Mon, 01 May 2023
4 6382 Mon, 01 May 2023 13:41
By: Barbara Boehmer
  Group By (merged)
19C
By: deepakdot on Thu, 27 April 2023
4 11967 Thu, 27 April 2023 23:54
By: deepakdot
  How can I speed this query up?
By: DevMuch on Thu, 27 April 2023
2 9054 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 19060 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 12386 Sat, 22 April 2023 06:18
By: Solomon Yakobson
  SQL Query help
Oracle 12c, Linux
By: rajivn786 on Sun, 16 April 2023
2 17265 Mon, 17 April 2023 15:56
By: Solomon Yakobson
  Format Dollar and Date Fields
By: _rachel_ on Wed, 12 April 2023
4 10460 Thu, 13 April 2023 04:42
By: Littlefoot
  sql query
19c
By: ora9a on Wed, 29 March 2023
10 17782 Wed, 12 April 2023 13:18
By: mathguy
  Subtrair valores
Oracle SQL Developer
By: FlaSouza on Mon, 10 April 2023
2 8399 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 12358 Sat, 08 April 2023 23:19
By: Barbara Boehmer
  Design issue
11.2.0.3.0
By: Amine on Fri, 07 April 2023
3 12081 Sat, 08 April 2023 17:50
By: mathguy
  difficult task
10g
By: urmas19 on Wed, 05 April 2023
7 6203 Wed, 05 April 2023 16:52
By: Barbara Boehmer
  Sequence alternate
19C
By: deepakdot on Tue, 28 March 2023
9 14808 Wed, 29 March 2023 07:49
By: Michel Cadot
  sql
oracle 10g
By: arun888 on Fri, 24 March 2023
2 16171 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 22277 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 15864 Thu, 23 March 2023 14:11
By: mathguy
  convert xml column value into columns
Oracle 19c
By: avtaritet on Mon, 20 March 2023
3 9830 Tue, 21 March 2023 09:20
By: avtaritet
  Refreshing Materialized View
oracle 10g
By: chat2raj.s on Sun, 13 November 2022
11 21786 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 20539 Thu, 16 March 2023 01:33
By: OraFerro
  Suggestion on count via sql statement
Oracle 12c
By: akssre on Fri, 10 March 2023
14 13333 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 50228 Mon, 13 March 2023 19:29
By: mathguy
  XML parsing performance
19c
By: mape on Sun, 12 March 2023
0 15640 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 11706 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 19642 Tue, 07 March 2023 15:17
By: Michel Cadot
  Grouping with the previous one if identical
By: questvba on Tue, 21 February 2023
12 25314 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 20944 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 4714 Mon, 06 March 2023 01:05
By: Michel Cadot
  Optional parameter in Where clause
11g, Windows
By: RM33 on Fri, 24 February 2023
3 17971 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 23467 Fri, 17 February 2023 20:00
By: Duane
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 Mar 28 09:26:46 CDT 2024