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
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 765 Tue, 14 May 2019 13:39
By: Solomon Yakobson
  Package transfer from one to other oracle database
Oracle database 12.2 on Oracle Linux 7
By: armait on Tue, 07 May 2019
30 1742 Wed, 08 May 2019 09:42
By: Michel Cadot
  How to remove line breaks and put it in excel
Oracle11g
By: ssyr on Thu, 02 May 2019
6 958 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 848 Fri, 03 May 2019 10:07
By: _jum
  ORA-00933: SQL command not properly ended
Oracle Live SQL
By: davethewelder on Wed, 01 May 2019
8 1104 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 529 Wed, 01 May 2019 18:19
By: BlackSwan
  Design Question
12c
By: ora9a on Fri, 26 April 2019
17 1546 Wed, 01 May 2019 05:47
By: ora9a
  Converting returned rows into columns
Oracle 11
By: ssmith001 on Tue, 23 April 2019
3 938 Sun, 28 April 2019 06:26
By: Satheeshkumar.P
  Inserting %RowType objects "faster"
11g
By: andrew-mack on Tue, 23 April 2019
1 650 Tue, 23 April 2019 14:12
By: Michel Cadot
  Query taking 40 hours to execute
SQL developer
By: mjpatil on Mon, 22 April 2019
10 1126 Tue, 23 April 2019 04:11
By: cookiemonster
  pl/sql procedure compile error PLS-00103
11.2.0.4
By: calgary2019 on Mon, 22 April 2019
2 882 Mon, 22 April 2019 21:30
By: BlackSwan
  optimizer_feature_enable Hint
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Mon, 22 April 2019
6 703 Mon, 22 April 2019 10:24
By: Bill B
  update with subqueries possibilty
By: shahzad-ul-hasan on Mon, 22 April 2019
2 617 Mon, 22 April 2019 06:08
By: Solomon Yakobson
  update collection of object type using update statement
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: fachoch@gmail.com on Fri, 19 April 2019
4 850 Sat, 20 April 2019 09:47
By: Solomon Yakobson
  json fetching using JSON_TABLE
Oracle 12c
By: sss111ind on Thu, 18 April 2019
6 958 Sat, 20 April 2019 08:24
By: sss111ind
  Comparing daywise data
By: viveklnt on Sat, 20 April 2019
5 871 Sat, 20 April 2019 02:17
By: Michel Cadot
  Problem with selecting data
9.2.0.5.0
By: chrisk4@wp.pl on Wed, 17 April 2019
5 803 Wed, 17 April 2019 10:03
By: Michel Cadot
  Query running extremely slow
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Fri, 12 April 2019
14 7563 Wed, 17 April 2019 03:39
By: cookiemonster
  Carriage Return Finding
Oracle 11g,Windows
By: pstanand on Thu, 11 April 2019
15 1810 Fri, 12 April 2019 05:38
By: pstanand
  Explain plan attached
11g
By: venkat85 on Thu, 11 April 2019
3 1385 Fri, 12 April 2019 02:03
By: John Watson
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
32 7060 Fri, 12 April 2019 01:26
By: Michel Cadot
  Import XML file into XMLType Column
Database 11.2.0.2.0
By: ator on Fri, 05 April 2019
9 2012 Tue, 09 April 2019 10:20
By: Michel Cadot
  View my own queries
10g, RHEL 7
By: preet_kumar on Tue, 02 April 2019
6 1277 Mon, 08 April 2019 02:25
By: Roachcoach
  Import/Entry from txt file
SQL*Plus: Release 8.0.6.0.0 - Production
By: Salehin on Sat, 06 April 2019
6 1517 Sun, 07 April 2019 06:11
By: Michel Cadot
  How to split one column with dates into two with periods (from-to)
ORACLE DB
By: chrisk4@wp.pl on Sat, 06 April 2019
6 1613 Sat, 06 April 2019 11:03
By: chrisk4@wp.pl
  Storing only DATE I timestamp data type column
Oracle 12c
By: azeem87 on Thu, 04 April 2019
2 1106 Fri, 05 April 2019 00:03
By: Michel Cadot
  How To Retrieve string unto first pipe symbol in query
Oracle11g
By: ssyr on Fri, 29 March 2019
5 1908 Tue, 02 April 2019 14:03
By: Littlefoot
  Compare and contrast TRUNCATE and DELETE for a table
By: Meenakumari on Mon, 28 August 2017
9 10238 Tue, 02 April 2019 13:50
By: dragam
  Find next working day within the same period
PL SQL
By: EPerry123 on Tue, 02 April 2019
3 1065 Tue, 02 April 2019 05:24
By: John Watson
  How to send sms to no of mobile numbers using url in plsql procedure
By: ANIL747 on Sat, 30 March 2019
5 1633 Mon, 01 April 2019 14:32
By: Michel Cadot
  Error in materialized view refresh path
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 28 March 2019
16 2608 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 2424 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 2096 Wed, 27 March 2019 07:19
By: Bill B
  existing state of package - Invalidated
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 14 December 2017
17 5837 Mon, 25 March 2019 07:49
By: saipradyumn
  TO_NUMBER specify the decimal separator within a query.
Oracle 11g
By: Diego G. on Tue, 19 March 2019
6 2276 Fri, 22 March 2019 04:21
By: cookiemonster
icon1.gif read and validate file
Oracle Data Base 11g r2
By: Bartholomew Kuma on Tue, 19 March 2019
11 2623 Thu, 21 March 2019 00:36
By: Michel Cadot
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 2483 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 2293 Fri, 15 March 2019 05:33
By: ramya29p
  ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1720 ORA-29024: Certificate valida
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production, windows server 2008
By: 9a5e on Thu, 14 March 2019
13 3404 Fri, 15 March 2019 05:23
By: 9a5e
  SQL Data Extraction for CLOB
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: rahul1982 on Wed, 13 March 2019
10 2066 Wed, 13 March 2019 02:42
By: rahul1982
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: Wed Jul 17 19:43:47 CDT 2019