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
  Extract clob xml data to get node value
Oracle RDBMS, 12.1, Windows
By: unna on Mon, 13 May 2019
5 9080 Tue, 14 May 2019 15:57
By: unna
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 4440 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 7832 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 4505 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 3845 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 8681 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 2997 Wed, 01 May 2019 18:19
By: BlackSwan
  Converting returned rows into columns
Oracle 11
By: ssmith001 on Tue, 23 April 2019
3 3822 Sun, 28 April 2019 06:26
By: Satheeshkumar.P
  Inserting %RowType objects "faster"
11g
By: andrew-mack on Tue, 23 April 2019
1 2988 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 5043 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 3861 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 3352 Mon, 22 April 2019 10:24
By: Bill B
  update with subqueries possibilty
By: shahzad-ul-hasan on Mon, 22 April 2019
2 2749 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 4138 Sat, 20 April 2019 09:47
By: Solomon Yakobson
  json fetching using JSON_TABLE
Oracle 12c
By: sss111ind on Thu, 18 April 2019
6 4355 Sat, 20 April 2019 08:24
By: sss111ind
  Comparing daywise data
By: viveklnt on Sat, 20 April 2019
5 3670 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 3993 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 12802 Wed, 17 April 2019 03:39
By: cookiemonster
  Carriage Return Finding
Oracle 11g,Windows
By: pstanand on Thu, 11 April 2019
15 5483 Fri, 12 April 2019 05:38
By: pstanand
  Explain plan attached
11g
By: venkat85 on Thu, 11 April 2019
3 3581 Fri, 12 April 2019 02:03
By: John Watson
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
32 11618 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 6620 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 4179 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 4481 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 4665 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 3675 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 5121 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 13904 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 3227 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 5339 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 20724 Mon, 01 April 2019 10:04
By: saipradyumn
  how to replace date column
oracle 11gr2
By: tommm on Thu, 14 March 2019
6 7672 Wed, 27 March 2019 08:24
By: Michel Cadot
  Duplicate Insertion while executing Procedure
Oracle 12c
By: rajmat483 on Mon, 18 March 2019
5 5588 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 14489 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 11528 Fri, 22 March 2019 04:21
By: cookiemonster
icon14.gif trunc function and inner joins
By: rajmat483 on Thu, 07 March 2019
6 5808 Mon, 18 March 2019 06:32
By: Michel Cadot
  Performance of Virtual column referencing another table!
By: ramya29p on Fri, 15 March 2019
11 6370 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 23212 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 4777 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 6135 Tue, 12 March 2019 07:40
By: BlackSwan
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: Sat Feb 04 05:19:13 CST 2023