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
getting informations about processes Oracle 11 - Unix By: limner1977 on Thu, 12 September 2019	13	9891	Tue, 17 September 2019 10:35 By: limner1977
help around LIST_AGG function oracle 11gr2 By: rajeshkr on Fri, 13 September 2019	4	7043	Tue, 17 September 2019 08:50 By: rajeshkr
data masking Oracle 12c 2 By: sss111ind on Thu, 12 September 2019	6	6560	Fri, 13 September 2019 03:25 By: sss111ind
Sql query to group the values in comma seperated values Oracle DB 10.2.0.2 By: wantmannu on Wed, 11 September 2019	4	5424	Thu, 12 September 2019 10:13 By: Michel Cadot
what is utc and gmt Oracle 12c By: sss111ind on Wed, 11 September 2019	3	5333	Thu, 12 September 2019 06:26 By: sss111ind
View not pulling with updated table information APEX Oracle -PL/SQL By: WillJ on Tue, 10 September 2019	8	8942	Wed, 11 September 2019 07:28 By: WillJ
How To Show Column Value separated with colon as well as another column vlaue Oracle 11G By: ssyr on Tue, 10 September 2019	6	8415	Wed, 11 September 2019 07:14 By: ssyr
display data in new column By: getideas456@gmail.com on Fri, 06 September 2019	6	8192	Tue, 10 September 2019 06:25 By: getideas456@gmail.com
ORA-00001: unique constraint On Merge Insert Oracle11g By: ssyr on Fri, 30 August 2019	7	8904	Tue, 10 September 2019 00:19 By: Michel Cadot
Procedure SendMail Gmail Oracle 11 By: fabissilva on Mon, 09 September 2019	0	4303	Mon, 09 September 2019 14:14 By: fabissilva
BI Publisher Apex web Services Oracle 11g By: akarra on Mon, 09 September 2019	1	5709	Mon, 09 September 2019 12:59 By: akarra
IIF and Oracle Windows 2003 and Oracle 10g By: aijaz786 on Thu, 18 February 2010	16	20858	Fri, 06 September 2019 08:32 By: EdStevens
ORA-29913 ORA-29400 KUP-00554 Oracle 12c By: kavitha.raj23 on Tue, 03 September 2019	6	12391	Wed, 04 September 2019 06:40 By: EdStevens
How to remove ordinal suffixes after the numbers pl/sql developer, windows 10 By: nareshk00 on Thu, 29 August 2019	10	9368	Fri, 30 August 2019 13:47 By: nareshk00
Purging Data From table! By: ramya29p on Thu, 04 July 2019	22	19822	Fri, 30 August 2019 02:01 By: oracledev
Additional Column Indicator for Failed or Passed Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: wtolentino on Thu, 29 August 2019	2	5213	Thu, 29 August 2019 11:45 By: wtolentino
Create table as select Oracle 11.2, AIX By: corina on Wed, 28 August 2019	6	6606	Thu, 29 August 2019 10:38 By: Michel Cadot
help with sql grouping By: ramkumar10 on Thu, 10 August 2017	6	8060	Wed, 28 August 2019 17:01 By: ramkumar10
Help with sql using analytical functions. By: ramkumar10 on Thu, 22 August 2019	4	8287	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	7846	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	7660	Fri, 23 August 2019 01:59 By: vippysharma
Bursting Program is not being Submitted By: vharish006 on Wed, 21 August 2019	1	6837	Wed, 21 August 2019 14:58 By: Michel Cadot
regexp_replace Oracle 12c By: sss111ind on Fri, 16 August 2019	6	6136	Tue, 20 August 2019 01:50 By: sss111ind
xml generation from db Oracle 12c 2 By: sss111ind on Wed, 14 August 2019	1	4707	Mon, 19 August 2019 03:47 By: sss111ind
plsql logic By: yashi7777 on Fri, 16 August 2019	10	7738	Sat, 17 August 2019 10:23 By: Michel Cadot
Data spliting 11gr2 By: rajeshkr on Mon, 12 August 2019	5	6030	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	6261	Fri, 16 August 2019 06:22 By: Bill B
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019	18	11071	Fri, 16 August 2019 05:50 By: Bill B
REQEXP_SUBTR debug 11i By: Mani Balan on Thu, 08 August 2019	3	5354	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	5608	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	6427	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	9563	Thu, 08 August 2019 00:37 By: Michel Cadot
Oracle insert statement Oracle 12 By: anand.doss on Sat, 03 August 2019	2	5701	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	8810	Mon, 05 August 2019 03:00 By: cookiemonster
Convert Columns to rows win 8,Oracle 10g By: Xandot on Thu, 20 November 2014	7	7462	Tue, 30 July 2019 02:56 By: Michel Cadot
Leading zeros in a spool file By: Mike Bentley on Wed, 20 December 2006	6	13204	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	14241	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	10586	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	6804	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	4971	Wed, 24 July 2019 14:16 By: Michel Cadot