OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Is it possible to insert a folder from a directory into a table? Oracle Data Base 11g r2 By: Bartholomew Kuma on Mon, 05 August 2019	12	5610	Thu, 08 August 2019 00:37 By: Michel Cadot
read and validate file Oracle Data Base 11g r2 By: Bartholomew Kuma on Tue, 19 March 2019	13	8642	Tue, 06 August 2019 12:57 By: Michel Cadot
Oracle insert statement Oracle 12 By: anand.doss on Sat, 03 August 2019	2	3035	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	5081	Mon, 05 August 2019 03:00 By: cookiemonster
Convert Columns to rows win 8,Oracle 10g By: Xandot on Thu, 20 November 2014	7	4844	Tue, 30 July 2019 02:56 By: Michel Cadot
Leading zeros in a spool file By: Mike Bentley on Wed, 20 December 2006	6	10154	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	8597	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	6103	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	3810	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	3062	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	13643	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	3885	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	118990	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	5361	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	8137	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	3371	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	4978	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	5000	Sun, 07 July 2019 20:48 By: mvs2019
Automatic abropting the long running job Oracle 12c By: sss111ind on Wed, 03 July 2019	8	6630	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	6173	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	8045	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	10662	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	5751	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	7015	Wed, 12 June 2019 10:23 By: cookiemonster
Backup Oracle 11.1 , linux By: Manishkumar on Sun, 09 June 2019	20	8676	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	11289	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	6025	Thu, 06 June 2019 06:43 By: maik2910
Combining 3 queries into 1 Oracle11g By: ssyr on Wed, 05 June 2019	5	4109	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	4188	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	4643	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	4300	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	2992	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	3682	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	35035	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	4947	Fri, 24 May 2019 08:06 By: EdStevens
case if avec PL/SQL By: sawssen on Wed, 22 May 2019	1	3292	Thu, 23 May 2019 00:20 By: Michel Cadot
Help in building a Query By: spirit3d on Mon, 20 May 2019	4	4655	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	2971	Tue, 21 May 2019 06:37 By: Bill B
minus query using dblink Oracle 12 By: sivakumar121 on Sat, 18 May 2019	4	3995	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	6109	Mon, 20 May 2019 11:47 By: Bill B