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
  Single update to get one column value using another column value
Oracle 12c
By: sss111ind on Tue, 25 February 2020
12 1224 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 3499 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 3336 Sat, 22 February 2020 08:31
By: EdStevens
  Start Transactional Control in PL/SQL
Oracle Database
By: aks11 on Wed, 19 February 2020
6 2685 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 1663 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 1785 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 1252 Mon, 17 February 2020 07:10
By: Bill B
  AS_XLSX. how to set worksheet name
By: calacausi on Mon, 17 February 2020
4 1306 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 975 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 2320 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 1571 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 3802 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 3708 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 2573 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 3062 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 3280 Mon, 03 February 2020 00:19
By: jgjeetu
  Calling webservice from plsql package (merged)
Oracle12c
By: Shiv93 on Sun, 05 January 2020
5 6329 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 1054 Thu, 30 January 2020 04:08
By: John Watson
  DB link issue in cloned databases on same host
11.1.0.7.0
By: aloksk on Tue, 28 January 2020
7 2767 Tue, 28 January 2020 23:50
By: aloksk
  Writing from Ref cursor to UTIL file
Oracle 11g
By: Samhita_Varma on Mon, 27 January 2020
2 2712 Mon, 27 January 2020 09:56
By: Michel Cadot
  Design Question
12c ( 1 2)
By: ora9a on Fri, 26 April 2019
43 8027 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 1758 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 2112 Wed, 22 January 2020 23:38
By: shobhakashyapgmailcom
  Query on Oracle JVM
Oracle 11g
By: IshwaryaMurali on Tue, 21 January 2020
4 1849 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 2244 Tue, 21 January 2020 00:39
By: Michel Cadot
  Hierarchy Queries
By: msinha8 on Mon, 23 December 2019
16 6528 Fri, 10 January 2020 10:22
By: msinha8
  DML operation on a table
12C
By: deepakdot on Fri, 10 January 2020
2 2570 Fri, 10 January 2020 05:12
By: deepakdot
  ORA-03001 while using bulk collect
By: shanthkumaar on Fri, 16 March 2007
4 7622 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 5783 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 1685 Mon, 06 January 2020 02:30
By: OraFerro
  Error performing insert
Oracle Sql Developed
By: Xbox2019 on Thu, 02 January 2020
1 3282 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 3776 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 4199 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 13351 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 2943 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 4970 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 3461 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 3331 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 1798 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 7697 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: Sun May 31 19:10:10 CDT 2020