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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 5634 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 206239 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  Load multiline data in table using sql loader
Oracle 12c
By: adfire05 on Mon, 15 July 2019
10 589 Tue, 16 July 2019 14:10
By: BlackSwan
  Sending table data in HTML format through PL/SQL
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
By: NewLife on Fri, 11 July 2008
17 106925 Tue, 16 July 2019 07:51
By: cookiemonster
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
15 2118 Mon, 15 July 2019 04:33
By: John Watson
  MV Refresh On Commit
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 06 June 2019
2 2254 Mon, 15 July 2019 00:39
By: saipradyumn
  Returning into clause for insert selectstatements
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 07 June 2019
6 3493 Mon, 15 July 2019 00:26
By: saipradyumn
  ALTER INDEX To Add the Extra columns
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 12 July 2019
3 404 Fri, 12 July 2019 13:14
By: John Watson
  Different Values of RAWTOHEX in Oracle 12c and 11g
Oracle 12.1.0.2.0 and Oracle 11.2.0.1.0 Both Enterprise Editions
By: Manoj.Gupta.91 on Fri, 12 July 2019
3 401 Fri, 12 July 2019 10:31
By: Michel Cadot
  MAX(DECODE
Oracle 8i, Windows ver 6.1
By: kumarvk on Mon, 08 July 2019
7 1059 Thu, 11 July 2019 06:03
By: cookiemonster
  Trying to Report on Date Periods within a table
Oracle 12C
By: mvs2019 on Sat, 06 July 2019
6 780 Sun, 07 July 2019 20:48
By: mvs2019
  Automatic abropting the long running job
Oracle 12c
By: sss111ind on Wed, 03 July 2019
8 1419 Sat, 06 July 2019 07:28
By: BlackSwan
  How to Create variable out of Table Type Variable!
By: ramya29p on Mon, 24 June 2019
7 1562 Mon, 24 June 2019 12:38
By: BlackSwan
  Incorrect work of the sql query with JOIN.
Oracle, 11g, Win 7
By: orajav on Thu, 13 June 2019
18 2968 Fri, 14 June 2019 05:50
By: orajav
  Using the Sql query to find employees who were recruited on the same day or on neighboring days.
Oracle, 11g, Win 7
By: orajav on Wed, 12 June 2019
21 3278 Thu, 13 June 2019 12:46
By: orajav
  How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va
oracle 11g
By: Piranava on Mon, 10 June 2019
3 2467 Thu, 13 June 2019 07:24
By: Bill B
  How to build a query that gets its values from a file
Oracle SQL Developer Version 4.0.1.14 / windows 7.0
By: hartyshow@yahoo.fr on Tue, 11 June 2019
10 2007 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 4406 Tue, 11 June 2019 12:35
By: Bill B
  Aggregate operation on array
11.2.0.1.0
By: OraFerro on Thu, 30 May 2019
20 5043 Tue, 11 June 2019 03:56
By: OraFerro
  PLS-00306: wrong number or types of arguments in call to 'FOPEN' (CM merged 2)
Oracle 11GR2
By: maik2910 on Wed, 05 June 2019
4 1103 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 905 Wed, 05 June 2019 11:15
By: Bill B
  Approximate 50MB files per day to be saved in Oracle Database
Oracle 11gR2
By: srinivas.k2005 on Thu, 30 May 2019
1 1761 Mon, 03 June 2019 12:31
By: Bill B
  select START_TIME = TO_DATE returns 0
RDBMS 12.2..0.1 on linux
By: evoradba on Wed, 29 May 2019
5 1316 Mon, 03 June 2019 11:01
By: Bill B
  How to write SQL Query to get desire output
oracle 12c
By: shawaj on Fri, 31 May 2019
3 1272 Sun, 02 June 2019 23:38
By: shawaj
  varchar2 byte or char semantics
db any version
By: John Watson on Wed, 29 May 2019
2 631 Wed, 29 May 2019 12:19
By: John Watson
  json filter unusual behaviour
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: sss111ind on Wed, 29 May 2019
3 682 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 26259 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 1232 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 653 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 909 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 553 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 724 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 979 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 1348 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 1092 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 578 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 821 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 685 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 4472 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 784 Tue, 14 May 2019 15:57
By: unna
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:58:30 CDT 2019