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
  Select query took too long to execute on one schema but very little time on another scema
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Wed, 24 July 2019
16 8347 Fri, 26 July 2019 07:42
By: Michel Cadot
  How to use sysdate as a column header
Oracle 11g
By: chintan.patel on Wed, 24 July 2019
5 5464 Thu, 25 July 2019 07:39
By: Solomon Yakobson
  Case insensitive in oracle 12c
RDBMS 12.2..0.1 on linux
By: evoradba on Wed, 24 July 2019
1 4045 Wed, 24 July 2019 14:16
By: Michel Cadot
  How to get the file name from directory
Oracle 10g
By: sss111ind on Wed, 12 December 2012
15 16509 Mon, 22 July 2019 07:52
By: EdStevens
  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 5123 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 123121 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 6275 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 9465 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 4786 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 6343 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 6509 Sun, 07 July 2019 20:48
By: mvs2019
  Automatic abropting the long running job
Oracle 12c
By: sss111ind on Wed, 03 July 2019
8 9467 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 8344 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 10174 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 13680 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 7328 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 8741 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 10947 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 13751 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 7809 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 5347 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 5071 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 5785 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 5162 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 3920 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 4804 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 38775 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 6079 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 4198 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 6126 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 3869 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 5633 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 9484 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 8260 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 9002 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 4084 Fri, 17 May 2019 14:00
By: Bill B
  month as columns
12c
By: m.abdulhaq on Sun, 12 May 2019
4 4197 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 3982 Wed, 15 May 2019 15:05
By: buggleboy007
  Update in EXECUTE IMMEDIATE
Oracle 11G
By: RaShi.Raj on Mon, 11 April 2016
34 15611 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 12195 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: Fri Apr 19 15:25:29 CDT 2024