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
  Repeat Rows based on column value (merged by CM)
By: cplib on Wed, 19 May 2010
15 6490 Tue, 15 August 2023 16:54
By: M117
  Last N TRANSACTIONS for each customer (syntax error)
19c
By: Unclefool on Tue, 08 August 2023
6 9335 Tue, 08 August 2023 14:26
By: Barbara Boehmer
  Log errors reject limit unlimited
Oracle 12.2
By: pointers on Tue, 08 August 2023
3 7246 Tue, 08 August 2023 11:27
By: Solomon Yakobson
  DBMS_SQL.PARSE
Forms 6i Oracle Database 19c
By: chat2raj.s on Mon, 07 August 2023
7 7010 Tue, 08 August 2023 08:26
By: Solomon Yakobson
  How to Delimit the Large comma separated string - Oracle Procedure
oracle 12c
By: born2achieve on Mon, 31 July 2023
6 11973 Tue, 01 August 2023 11:46
By: born2achieve
  Merge using rownum
12.1.0.1
By: OraFerro on Mon, 31 July 2023
2 10287 Tue, 01 August 2023 05:18
By: OraFerro
  Display 3rd highest salary (join)
19c
By: Unclefool on Mon, 31 July 2023
5 8583 Mon, 31 July 2023 13:13
By: Solomon Yakobson
  Updating a Hijri date in oracle date column
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: chat2raj.s on Thu, 20 July 2023
4 17277 Thu, 27 July 2023 23:56
By: chat2raj.s
  Finding initial, final, in_between, and initial_and_final events
By: manubatham20 on Thu, 20 July 2023
8 9861 Thu, 20 July 2023 21:46
By: mathguy
  Duplicate Rows
19C
By: deepakdot on Wed, 21 June 2023
4 18226 Tue, 18 July 2023 20:01
By: mathguy
  Question on Pivot columns
Oracle 19.0.0.0.0
By: manoj12 on Mon, 10 July 2023
5 11015 Tue, 18 July 2023 13:02
By: mathguy
  order by union query
Form 6i, Database10g
By: shahzad-ul-hasan on Wed, 28 June 2023
7 20595 Tue, 18 July 2023 12:55
By: mathguy
  DDL generation
Oracle Database 19.10 Linux x86_64
By: smunir362 on Sat, 15 July 2023
5 7877 Mon, 17 July 2023 13:13
By: Solomon Yakobson
  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 15768 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 15934 Sat, 24 June 2023 13:19
By: Barbara Boehmer
  Oracle function to get account balance
19c
By: Unclefool on Fri, 23 June 2023
2 13368 Fri, 23 June 2023 11:30
By: Michel Cadot
  Letter and TIMESTAMP CONCAT (INSERT error)
19c
By: Unclefool on Sat, 17 June 2023
4 9107 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 14988 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 22134 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 12759 Thu, 18 May 2023 08:06
By: Michel Cadot
  Wrap Triggers
Oracle 19c
By: sinpeak on Tue, 16 May 2023
2 10077 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 10006 Mon, 15 May 2023 07:02
By: ashnamalik
  reading all values of json table
Oracle 19c
By: sss111ind on Wed, 10 May 2023
2 14026 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 21221 Tue, 09 May 2023 02:58
By: pointers
  Join purchases to customers
19c
By: Unclefool on Mon, 01 May 2023
4 6630 Mon, 01 May 2023 13:41
By: Barbara Boehmer
  Group By (merged)
19C
By: deepakdot on Thu, 27 April 2023
4 12245 Thu, 27 April 2023 23:54
By: deepakdot
  How can I speed this query up?
By: DevMuch on Thu, 27 April 2023
2 9294 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 19385 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 12826 Sat, 22 April 2023 06:18
By: Solomon Yakobson
  SQL Query help
Oracle 12c, Linux
By: rajivn786 on Sun, 16 April 2023
2 17529 Mon, 17 April 2023 15:56
By: Solomon Yakobson
  Format Dollar and Date Fields
By: _rachel_ on Wed, 12 April 2023
4 10725 Thu, 13 April 2023 04:42
By: Littlefoot
  sql query
19c
By: ora9a on Wed, 29 March 2023
10 18082 Wed, 12 April 2023 13:18
By: mathguy
  Subtrair valores
Oracle SQL Developer
By: FlaSouza on Mon, 10 April 2023
2 8679 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 12667 Sat, 08 April 2023 23:19
By: Barbara Boehmer
  Design issue
11.2.0.3.0
By: Amine on Fri, 07 April 2023
3 12338 Sat, 08 April 2023 17:50
By: mathguy
  difficult task
10g
By: urmas19 on Wed, 05 April 2023
7 6457 Wed, 05 April 2023 16:52
By: Barbara Boehmer
  Sequence alternate
19C
By: deepakdot on Tue, 28 March 2023
9 15116 Wed, 29 March 2023 07:49
By: Michel Cadot
  sql
oracle 10g
By: arun888 on Fri, 24 March 2023
2 16473 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 22568 Fri, 24 March 2023 01:46
By: arun888
  xml converting task
11g
By: urmas19 on Wed, 22 March 2023
7 16130 Thu, 23 March 2023 14:11
By: mathguy
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: Fri May 24 11:13:21 CDT 2024