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
  Get (and lock) first unlocked row?!
By: emirc on Mon, 16 May 2005
8 15724 Wed, 26 February 2020 06:54
By: EdStevens
  Single update to get one column value using another column value
Oracle 12c
By: sss111ind on Tue, 25 February 2020
12 1513 Tue, 25 February 2020 07:44
By: sss111ind
  Return defined column size of varchar and varchar2 data types
By: jdbeyler on Fri, 21 February 2020
3 3766 Mon, 24 February 2020 05:55
By: Bill B
  Tab Delimited
Oracle Database 11g -Oracle JDBC driver- Linux
By: enriquemans on Fri, 21 February 2020
3 3598 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 2974 Fri, 21 February 2020 12:06
By: Bill B
  PLSQL: Execute Immediate is not working as expected in PLSQL anonymous block.
By: msyogi on Thu, 20 February 2020
4 1835 Thu, 20 February 2020 11:12
By: Michel Cadot
  How to export multiple blob and character data into a text file?
PL/SQL
By: Ethan Caleb on Tue, 18 February 2020
3 2091 Tue, 18 February 2020 21:32
By: BlackSwan
  How To Show Non Matching rows in oracle
Oracle 11G
By: ssyr on Sun, 16 February 2020
3 1443 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 1772 Mon, 17 February 2020 07:08
By: Bill B
  test failed: ORA-01017 invalid username / password access denied
By: syed.javid.ali.ali@gmail. on Sun, 16 February 2020
5 1262 Sun, 16 February 2020 14:56
By: EdStevens
  ORA-02085 database link AZZRE.CG44.FR connects to GZWR2.ZZ44.FR
Oracle 12.2, SLES12 SP3
By: Mat44 on Wed, 12 February 2020
8 2656 Thu, 13 February 2020 07:24
By: Solomon Yakobson
  ORA-20200: ORA-0000: normal, successful completion when executing PCRD_DF_MANAGEMENT.DF_MANAGE ORA
By: shilpanarayan94 on Wed, 12 February 2020
3 1955 Wed, 12 February 2020 08:58
By: Michel Cadot
  Simultaneous DML executions on different objects in the same session
11g and higher, any OS
By: Olexandr Siroklyn on Tue, 28 January 2020
12 4124 Mon, 10 February 2020 10:38
By: Olexandr Siroklyn
  Previous week's first and last day
Oracle 12
By: asagpariya on Thu, 06 February 2020
6 3990 Sat, 08 February 2020 10:35
By: Bill B
  Combining multiple regexp_like statements & correct regex syntax
By: mgarret40 on Mon, 03 February 2020
4 2849 Wed, 05 February 2020 01:25
By: Michel Cadot
  Delete statement to retain last 90 days of data
Oracle SQL IDE 4.0.3.16 Win2k8 Server
By: Jay76 on Fri, 31 January 2020
11 3294 Mon, 03 February 2020 06:03
By: Bill B
  ORA-12801: error signaled in parallel query server PXXX (merged 3)
oracle ,12c
By: jgjeetu on Fri, 31 January 2020
12 5532 Mon, 03 February 2020 00:19
By: jgjeetu
  Calling webservice from plsql package (merged)
Oracle12c
By: Shiv93 on Sun, 05 January 2020
5 6656 Fri, 31 January 2020 00:44
By: Shiv93
  How to download a BLOB field data to local storage (merged)
Oracle form 12c RDS
By: Shiv93 on Thu, 30 January 2020
2 1314 Thu, 30 January 2020 04:08
By: John Watson
  Writing from Ref cursor to UTIL file
Oracle 11g
By: Samhita_Varma on Mon, 27 January 2020
2 2997 Mon, 27 January 2020 09:56
By: Michel Cadot
  Design Question
12c ( 1 2)
By: ora9a on Fri, 26 April 2019
43 8341 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 2187 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 2282 Wed, 22 January 2020 23:38
By: shobhakashyapgmailcom
  Query on Oracle JVM
Oracle 11g
By: IshwaryaMurali on Tue, 21 January 2020
4 2121 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 2591 Tue, 21 January 2020 00:39
By: Michel Cadot
  Hierarchy Queries
By: msinha8 on Mon, 23 December 2019
16 6897 Fri, 10 January 2020 10:22
By: msinha8
  DML operation on a table
12C
By: deepakdot on Fri, 10 January 2020
2 2826 Fri, 10 January 2020 05:12
By: deepakdot
  ORA-03001 while using bulk collect
By: shanthkumaar on Fri, 16 March 2007
4 8085 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 6272 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 1948 Mon, 06 January 2020 02:30
By: OraFerro
  Error performing insert
Oracle Sql Developed
By: Xbox2019 on Thu, 02 January 2020
1 3553 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 4077 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 4498 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 14160 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 3222 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 5235 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 3835 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 3715 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 2078 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 8162 Mon, 09 December 2019 09:51
By: ramsql
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 Sep 25 12:47:13 CDT 2020