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
  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
5 5062 Thu, 18 July 2019 14:08
By: Lalit Kumar B
  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 123014 Tue, 16 July 2019 07:51
By: cookiemonster
  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 6218 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 9381 Mon, 15 July 2019 00:26
By: saipradyumn
  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 4727 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 6284 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 6452 Sun, 07 July 2019 20:48
By: mvs2019
  Automatic abropting the long running job
Oracle 12c
By: sss111ind on Wed, 03 July 2019
8 9358 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 8256 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 10111 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 13611 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 7259 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 8682 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 10884 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 13674 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 7721 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 5291 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 5025 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 5732 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 5105 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 3865 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 4744 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 38697 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 6003 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 4141 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 6070 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 3818 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 5548 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 9333 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 8191 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 8924 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 4027 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 4145 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 3933 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 15488 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 12065 Tue, 14 May 2019 15:57
By: unna
  Why does my SQL not work?
By: jvanh on Tue, 14 May 2019
10 5103 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 8900 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 5227 Mon, 06 May 2019 06:01
By: Bill B
  parent value of xmlquery
Oracle 12C
By: hakan_8 on Fri, 03 May 2019
4 4630 Fri, 03 May 2019 10:07
By: _jum
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 Mar 28 16:07:05 CDT 2024