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
  Package transfer from one to other oracle database
Oracle database 12.2 on Oracle Linux 7
By: armait on Tue, 07 May 2019
30 3861 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 1927 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 1801 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 2796 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 1292 Wed, 01 May 2019 18:19
By: BlackSwan
  Converting returned rows into columns
Oracle 11
By: ssmith001 on Tue, 23 April 2019
3 1802 Sun, 28 April 2019 06:26
By: Satheeshkumar.P
  Inserting %RowType objects "faster"
11g
By: andrew-mack on Tue, 23 April 2019
1 1428 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 2314 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 1970 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 1456 Mon, 22 April 2019 10:24
By: Bill B
  update with subqueries possibilty
By: shahzad-ul-hasan on Mon, 22 April 2019
2 1228 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 1717 Sat, 20 April 2019 09:47
By: Solomon Yakobson
  json fetching using JSON_TABLE
Oracle 12c
By: sss111ind on Thu, 18 April 2019
6 1864 Sat, 20 April 2019 08:24
By: sss111ind
  Comparing daywise data
By: viveklnt on Sat, 20 April 2019
5 1811 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 1731 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 8974 Wed, 17 April 2019 03:39
By: cookiemonster
  Carriage Return Finding
Oracle 11g,Windows
By: pstanand on Thu, 11 April 2019
15 3180 Fri, 12 April 2019 05:38
By: pstanand
  Explain plan attached
11g
By: venkat85 on Thu, 11 April 2019
3 2007 Fri, 12 April 2019 02:03
By: John Watson
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
32 8743 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 3418 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 1978 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 2420 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 2749 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 1797 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 2956 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 11581 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 1836 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 2692 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 6105 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 3723 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 3037 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 7612 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 3554 Fri, 22 March 2019 04:21
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 3369 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 3664 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 8232 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 2950 Wed, 13 March 2019 02:42
By: rahul1982
  how can I allow this procedure to attach to email(pdf file in the directory), pdf file that is > 32
Oracle Database 12c
By: Nembezah on Tue, 19 February 2019
2 3782 Tue, 12 March 2019 07:40
By: BlackSwan
  Replacing bulk collect with loop
11.2.0.1.0
By: OraFerro on Wed, 06 March 2019
12 3662 Mon, 11 March 2019 08:21
By: BlackSwan
  Need suggestion on code refactoring
oracle 11g
By: harishankar_kar on Thu, 14 February 2019
14 4558 Sat, 09 March 2019 13:51
By: harishankar_kar
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 Jan 23 03:07:47 CST 2020