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
  json filter unusual behaviour
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: sss111ind on Wed, 29 May 2019
3 2730 Wed, 29 May 2019 07:48
By: cookiemonster
  can we call an sql script from the code of a stored procedure
By: santosh_only on Thu, 25 May 2006
28 31663 Mon, 27 May 2019 04:24
By: William Robertson
  How to get all child records from a table with multiple self referential integrity constraints? (merged 3)
11g
By: rrcr on Thu, 23 May 2019
8 4088 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 2490 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 3253 Tue, 21 May 2019 06:50
By: Bill B
  Sql query taking long time to execut
By: haider_1pk on Tue, 21 May 2019
2 2134 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 2707 Mon, 20 May 2019 11:50
By: Bill B
  Loop after fetch on generic SYS_REFCURSOR
11.2.0.1.0
By: OraFerro on Sun, 19 May 2019
9 3862 Mon, 20 May 2019 11:47
By: Bill B
  Error: ORA-00980: synonym translation is no longer valid
By: abs on Thu, 09 May 2019
5 4486 Mon, 20 May 2019 01:09
By: sandycullen
  Disable FND_FILE.PUT_LINE(FND_FILE.LOG
12.0.1.2
By: vaibhav15211 on Thu, 16 May 2019
8 4006 Sat, 18 May 2019 00:33
By: Michel Cadot
  write to the file from PL SQL
oracle 11
By: ykozhevnikov on Fri, 17 May 2019
3 2150 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 2464 Thu, 16 May 2019 01:34
By: m.abdulhaq
  How to get or concatenate a value from inner most query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Tue, 14 May 2019
2 2226 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 9041 Wed, 15 May 2019 12:39
By: cookiemonster
  Extract clob xml data to get node value
Oracle RDBMS, 12.1, Windows
By: unna on Mon, 13 May 2019
5 3251 Tue, 14 May 2019 15:57
By: unna
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 2699 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 4786 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 2668 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 2547 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 4775 Thu, 02 May 2019 09:54
By: cookiemonster
  Runtime data stored in tables
By: hapr1 on Wed, 01 May 2019
1 1778 Wed, 01 May 2019 18:19
By: BlackSwan
  Converting returned rows into columns
Oracle 11
By: ssmith001 on Tue, 23 April 2019
3 2470 Sun, 28 April 2019 06:26
By: Satheeshkumar.P
  Inserting %RowType objects "faster"
11g
By: andrew-mack on Tue, 23 April 2019
1 1996 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 3133 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 2566 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 2195 Mon, 22 April 2019 10:24
By: Bill B
  update with subqueries possibilty
By: shahzad-ul-hasan on Mon, 22 April 2019
2 1775 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 2441 Sat, 20 April 2019 09:47
By: Solomon Yakobson
  json fetching using JSON_TABLE
Oracle 12c
By: sss111ind on Thu, 18 April 2019
6 2562 Sat, 20 April 2019 08:24
By: sss111ind
  Comparing daywise data
By: viveklnt on Sat, 20 April 2019
5 2545 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 2393 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 9769 Wed, 17 April 2019 03:39
By: cookiemonster
  Carriage Return Finding
Oracle 11g,Windows
By: pstanand on Thu, 11 April 2019
15 4184 Fri, 12 April 2019 05:38
By: pstanand
  Explain plan attached
11g
By: venkat85 on Thu, 11 April 2019
3 2673 Fri, 12 April 2019 02:03
By: John Watson
  running balance query
10g, win8.1
By: rzkhan on Thu, 14 April 2016
32 9690 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 4680 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 2431 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 3071 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 3453 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 2373 Fri, 05 April 2019 00:03
By: Michel Cadot
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 Jan 23 01:54:32 CST 2021