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
Help with sql using analytical functions. By: ramkumar10 on Thu, 22 August 2019	4	6485	Wed, 28 August 2019 00:33 By: Michel Cadot
Compare two tables to find new/modified/removed records Oracle DB 11g Enterprise Edition 11.2.0.4.0 - 64bit / Windows 7 x64 By: nickz on Thu, 22 August 2019	3	6074	Fri, 23 August 2019 09:12 By: Bill B
Dynamic Logic Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: vippysharma on Tue, 20 August 2019	5	5721	Fri, 23 August 2019 01:59 By: vippysharma
Bursting Program is not being Submitted By: vharish006 on Wed, 21 August 2019	1	4681	Wed, 21 August 2019 14:58 By: Michel Cadot
regexp_replace Oracle 12c By: sss111ind on Fri, 16 August 2019	6	4271	Tue, 20 August 2019 01:50 By: sss111ind
xml generation from db Oracle 12c 2 By: sss111ind on Wed, 14 August 2019	1	3039	Mon, 19 August 2019 03:47 By: sss111ind
plsql logic By: yashi7777 on Fri, 16 August 2019	10	5336	Sat, 17 August 2019 10:23 By: Michel Cadot
Data spliting 11gr2 By: rajeshkr on Mon, 12 August 2019	5	4150	Fri, 16 August 2019 08:46 By: rajeshkr
Materialized View Query Oracle SQL Developer 4.2.0 By: baboyjames on Thu, 25 July 2019	3	4385	Fri, 16 August 2019 06:22 By: Bill B
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019	18	8435	Fri, 16 August 2019 05:50 By: Bill B
REQEXP_SUBTR debug 11i By: Mani Balan on Thu, 08 August 2019	3	3544	Tue, 13 August 2019 14:15 By: Michel Cadot
Union and sort the data based on date range 11G By: laknar on Wed, 07 August 2019	2	3522	Thu, 08 August 2019 00:41 By: Michel Cadot
Comprimir una imagen utilizando AS_ZIP Oracle Database 11g Release 11.2.0.4.0 By: Bartholomew Kuma on Wed, 07 August 2019	3	4460	Thu, 08 August 2019 00:38 By: Michel Cadot
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	6720	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	9894	Tue, 06 August 2019 12:57 By: Michel Cadot
Oracle insert statement Oracle 12 By: anand.doss on Sat, 03 August 2019	2	3609	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	6495	Mon, 05 August 2019 03:00 By: cookiemonster
Convert Columns to rows win 8,Oracle 10g By: Xandot on Thu, 20 November 2014	7	5452	Tue, 30 July 2019 02:56 By: Michel Cadot
Leading zeros in a spool file By: Mike Bentley on Wed, 20 December 2006	6	10971	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	10484	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	7321	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	4588	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	3423	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	14800	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	4497	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	121109	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	5671	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	8715	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	3964	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	5667	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	5721	Sun, 07 July 2019 20:48 By: mvs2019
Automatic abropting the long running job Oracle 12c By: sss111ind on Wed, 03 July 2019	8	8114	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	7172	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	9280	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	12187	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	6405	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	7980	Wed, 12 June 2019 10:23 By: cookiemonster
Backup Oracle 11.1 , linux By: Manishkumar on Sun, 09 June 2019	20	9927	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	12673	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	6689	Thu, 06 June 2019 06:43 By: maik2910