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
  Writing from Ref cursor to UTIL file
Oracle 11g
By: Samhita_Varma on Mon, 27 January 2020
2 6104 Mon, 27 January 2020 09:56
By: Michel Cadot
  Design Question
12c ( 1 2)
By: ora9a on Fri, 26 April 2019
43 19210 Sat, 25 January 2020 02:35
By: Michel Cadot
  Looping through dblinks with a cursor
Oracle 12.2.0.1, RHEL 6.10
By: scoogie1973 on Thu, 23 January 2020
9 8606 Fri, 24 January 2020 01:45
By: John Watson
  XMLQUERY: ORA-01427: single-row subquery returns more than one row
oracle 12g
By: shobhakashyapgmailcom on Sun, 19 January 2020
4 5257 Wed, 22 January 2020 23:38
By: shobhakashyapgmailcom
  Query on Oracle JVM
Oracle 11g
By: IshwaryaMurali on Tue, 21 January 2020
4 5424 Wed, 22 January 2020 04:51
By: IshwaryaMurali
  ORA-00604 & ORA-28003 - Even when not trying to change password
oracle 11g
By: IshwaryaMurali on Fri, 17 January 2020
7 6710 Tue, 21 January 2020 00:39
By: Michel Cadot
  Hierarchy Queries
By: msinha8 on Mon, 23 December 2019
16 12379 Fri, 10 January 2020 10:22
By: msinha8
  DML operation on a table
12C
By: deepakdot on Fri, 10 January 2020
2 5615 Fri, 10 January 2020 05:12
By: deepakdot
  ORA-03001 while using bulk collect
By: shanthkumaar on Fri, 16 March 2007
4 14413 Thu, 09 January 2020 06:30
By: Solomon Yakobson
  ORA-01031: insufficient privileges | Database level trigger
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: vippysharma on Wed, 25 December 2019
10 13715 Mon, 06 January 2020 04:17
By: cookiemonster
  Raise exception in case clause PL/SQL function
11.2.0.1.0
By: OraFerro on Mon, 06 January 2020
4 4973 Mon, 06 January 2020 02:30
By: OraFerro
  Error performing insert
Oracle Sql Developed
By: Xbox2019 on Thu, 02 January 2020
1 6320 Thu, 02 January 2020 12:19
By: Michel Cadot
  WITH Clause VS INLINE View Execution
Oracle 12C
By: ashrubhg@gmail.com on Mon, 30 December 2019
2 7963 Wed, 01 January 2020 06:17
By: John Watson
  Pan card insert time validation (3 merged)
Oracle 11g
By: Sivasai506 on Thu, 26 December 2019
4 8383 Mon, 30 December 2019 06:52
By: Bill B
  Validation of PAN Number in sql query
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
By: amarjadhav on Wed, 05 June 2013
16 27065 Mon, 30 December 2019 06:44
By: Bill B
  Trying to delete bunch of users using loop but failing
Oracle 12.2
By: a100 on Fri, 27 December 2019
6 6878 Fri, 27 December 2019 06:37
By: a100
  Output Dummy Record When No Record Exists
Oracle 12.2 Windows 2012
By: deay on Thu, 12 December 2019
5 8332 Thu, 12 December 2019 14:00
By: deay
  Using query to Fetch the records along with user defined column value (4 merged)
Oracle pl/sql
By: gsaravanan on Sun, 08 December 2019
5 7156 Wed, 11 December 2019 07:19
By: Bill B
  Materialized Views Cannot set with refresh Fast "Error"
Oracle 19
By: greatwhite on Mon, 09 December 2019
9 8654 Wed, 11 December 2019 05:58
By: Bill B
  How to Pass number value to a varchar field
By: asadkhan_2 on Mon, 09 December 2019
4 5402 Mon, 09 December 2019 11:18
By: Solomon Yakobson
  Rows into Columns (2 merged)
Oracle 10G, Windows 2012R2
By: hissam78 on Tue, 08 October 2019
11 12794 Mon, 09 December 2019 09:51
By: ramsql
  delete from table where one of the column is nested table is running long.
oracle
By: tdave2019 on Wed, 04 December 2019
7 8334 Thu, 05 December 2019 02:44
By: cookiemonster
  In SEND EMAIL code, how to remove Boundaries from the output
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: rappaj on Fri, 11 October 2019
32 21784 Wed, 04 December 2019 14:43
By: Michel Cadot
  Run Oracle SQL query multiple times with change in filter condition
12c
By: vsaenath on Mon, 02 December 2019
6 7046 Tue, 03 December 2019 10:38
By: flyboy
  Want to know insert into
By: kabina on Sat, 30 November 2019
3 5306 Sun, 01 December 2019 20:13
By: kabina
  Finding Date Pattern using LEAD
Oracle 12c
By: samiran_cts on Sun, 01 December 2019
8 6965 Sun, 01 December 2019 13:51
By: samiran_cts
  date format
SQL Developer
By: kabina on Wed, 27 November 2019
6 7263 Sat, 30 November 2019 08:05
By: EdStevens
  how to make table query in oracle (4 merged)
4.0.1.14
By: kabina on Wed, 27 November 2019
12 9812 Sat, 30 November 2019 02:11
By: John Watson
  ORA 01847
By: Satran on Wed, 27 November 2019
10 8815 Fri, 29 November 2019 09:08
By: cookiemonster
  bulk collect problem through dblink
Orale 12c, 12.1.0.2.0
By: mape on Sat, 23 November 2019
30 15324 Fri, 29 November 2019 07:22
By: Bill B
  Break line as per required attached output.
Oracle 11i
By: nitesh.erp@gmail.com on Sat, 23 November 2019
16 9817 Mon, 25 November 2019 05:39
By: nitesh.erp@gmail.com
  question for reverse
oracle 11g
By: manoj12 on Mon, 11 November 2019
6 8464 Fri, 22 November 2019 10:39
By: Bill B
  Record Plus Prior Record - Single Row
By: GIL149 on Fri, 15 November 2019
4 7871 Mon, 18 November 2019 10:00
By: JPBoileau
  Query performance condundrum.
Oracle 12c Linux
By: uman2631 on Fri, 15 November 2019
6 7609 Sat, 16 November 2019 11:41
By: John Watson
  Return TYpe (tablet) as output parameters.
Oracle
By: cristine_katia on Wed, 13 November 2019
7 9343 Fri, 15 November 2019 16:58
By: BlackSwan
icon5.gif who called my procedure through a database link
Oracle 10g
By: Bill B on Tue, 12 November 2019
8 8952 Fri, 15 November 2019 10:22
By: Bill B
  problem to show result in join tables
By: hassan08 on Sat, 09 November 2019
14 9936 Wed, 13 November 2019 11:21
By: Michel Cadot
  Ajuda com procedure Type Pipilined
Oracle
By: cristine_katia on Mon, 11 November 2019
13 10332 Tue, 12 November 2019 05:45
By: flyboy
  AWR Report SQL with Bind Variables
Oracle Version 12.1
By: kohila on Thu, 31 October 2019
8 11915 Wed, 06 November 2019 02:49
By: cookiemonster
  ALTER TABLE STATEMENT FOR CLUSTER
Oracle 19C/Window 10
By: Bilal Khan on Fri, 01 November 2019
7 8647 Sat, 02 November 2019 01:25
By: Michel Cadot
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 18:39:41 CDT 2024