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
icon1.gif read and validate file
Oracle Data Base 11g r2
By: Bartholomew Kuma on Tue, 19 March 2019
13 7054 Tue, 06 August 2019 12:57
By: Michel Cadot
  Oracle insert statement
Oracle 12
By: anand.doss on Sat, 03 August 2019
2 2223 Mon, 05 August 2019 07:35
By: Bill B
  Stored Procedures compile in 11G but do not in 12C (12.1.0.1.0)
Oracle 12.1.0.1.0 on a Windows 10
By: ALONG on Thu, 01 August 2019
8 3501 Mon, 05 August 2019 03:00
By: cookiemonster
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
7 3925 Tue, 30 July 2019 02:56
By: Michel Cadot
  Leading zeros in a spool file
By: Mike Bentley on Wed, 20 December 2006
6 8551 Mon, 29 July 2019 09:00
By: Bill B
  Load multiline data in table using sql loader
Oracle 12c
By: adfire05 on Mon, 15 July 2019
14 6623 Fri, 26 July 2019 12:31
By: adfire05
  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 4500 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 2652 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 2224 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 11586 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 2949 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 115887 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 4704 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 7269 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 2443 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 3847 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 3894 Sun, 07 July 2019 20:48
By: mvs2019
  Automatic abropting the long running job
Oracle 12c
By: sss111ind on Wed, 03 July 2019
8 5038 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 4568 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 6588 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 8874 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 4679 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 5787 Wed, 12 June 2019 10:23
By: cookiemonster
  Backup
Oracle 11.1 , linux
By: Manishkumar on Sun, 09 June 2019
20 7288 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 9340 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 4552 Thu, 06 June 2019 06:43
By: maik2910
  Combining 3 queries into 1
Oracle11g
By: ssyr on Wed, 05 June 2019
5 3166 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 3514 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 3805 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 3709 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 2380 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 2817 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 31866 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 4196 Fri, 24 May 2019 08:06
By: EdStevens
  case if avec PL/SQL
By: sawssen on Wed, 22 May 2019
1 2571 Thu, 23 May 2019 00:20
By: Michel Cadot
  Help in building a Query
By: spirit3d on Mon, 20 May 2019
4 3344 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 2215 Tue, 21 May 2019 06:37
By: Bill B
  minus query using dblink
Oracle 12
By: sivakumar121 on Sat, 18 May 2019
4 2816 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 4022 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 4648 Mon, 20 May 2019 01:09
By: sandycullen
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 Mar 05 12:47:01 CST 2021