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
date usage in SQL query By: James1116 on Mon, 23 September 2019	6	5549	Mon, 30 September 2019 05:46 By: Bill B
Need help with Error: subprogram or cursor reference is out of scope Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 By: rappaj on Thu, 26 September 2019	9	5161	Fri, 27 September 2019 08:48 By: rappaj
SQL to find Consecutive Halves By: patneel on Tue, 24 September 2019	2	3403	Wed, 25 September 2019 11:03 By: Solomon Yakobson
Writing Query but not getting desired output By: chavva.kiru@gmail.com on Tue, 24 September 2019	6	4593	Wed, 25 September 2019 05:50 By: flyboy
co related subquery written in Analytical functions By: chavva.kiru@gmail.com on Tue, 24 September 2019	3	3532	Wed, 25 September 2019 03:31 By: Michel Cadot
display issue By: James1116 on Tue, 24 September 2019	4	3309	Tue, 24 September 2019 13:20 By: Michel Cadot
RETURNING clause returns wrong value upon UPDATE statement Oracle 11g By: ermoadam on Mon, 23 September 2019	5	4427	Tue, 24 September 2019 02:21 By: Michel Cadot
How to call compiled procedure and function in a procedure Toad 11.5 with Oracle 10g By: oluranti on Sun, 22 September 2019	9	5655	Mon, 23 September 2019 10:25 By: cookiemonster
ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: revathitirun on Thu, 12 September 2019	5	7144	Fri, 20 September 2019 06:39 By: revathitirun
getting informations about processes Oracle 11 - Unix By: limner1977 on Thu, 12 September 2019	13	6372	Tue, 17 September 2019 10:35 By: limner1977
help around LIST_AGG function oracle 11gr2 By: rajeshkr on Fri, 13 September 2019	4	4594	Tue, 17 September 2019 08:50 By: rajeshkr
data masking Oracle 12c 2 By: sss111ind on Thu, 12 September 2019	6	3797	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	3295	Thu, 12 September 2019 10:13 By: Michel Cadot
what is utc and gmt Oracle 12c By: sss111ind on Wed, 11 September 2019	3	3115	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	5401	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	5070	Wed, 11 September 2019 07:14 By: ssyr
display data in new column By: getideas456@gmail.com on Fri, 06 September 2019	6	5100	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	5994	Tue, 10 September 2019 00:19 By: Michel Cadot
Procedure SendMail Gmail Oracle 11 By: fabissilva on Mon, 09 September 2019	0	2371	Mon, 09 September 2019 14:14 By: fabissilva
BI Publisher Apex web Services Oracle 11g By: akarra on Mon, 09 September 2019	1	3207	Mon, 09 September 2019 12:59 By: akarra
IIF and Oracle Windows 2003 and Oracle 10g By: aijaz786 on Thu, 18 February 2010	16	16176	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	7278	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	6036	Fri, 30 August 2019 13:47 By: nareshk00
Purging Data From table! By: ramya29p on Thu, 04 July 2019	22	13643	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	3138	Thu, 29 August 2019 11:45 By: wtolentino
Create table as select Oracle 11.2, AIX By: corina on Wed, 28 August 2019	6	4104	Thu, 29 August 2019 10:38 By: Michel Cadot
help with sql grouping By: ramkumar10 on Thu, 10 August 2017	6	5418	Wed, 28 August 2019 17:01 By: ramkumar10
Help with sql using analytical functions. By: ramkumar10 on Thu, 22 August 2019	4	6069	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	5699	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	5351	Fri, 23 August 2019 01:59 By: vippysharma
Bursting Program is not being Submitted By: vharish006 on Wed, 21 August 2019	1	4388	Wed, 21 August 2019 14:58 By: Michel Cadot
regexp_replace Oracle 12c By: sss111ind on Fri, 16 August 2019	6	3960	Tue, 20 August 2019 01:50 By: sss111ind
xml generation from db Oracle 12c 2 By: sss111ind on Wed, 14 August 2019	1	2768	Mon, 19 August 2019 03:47 By: sss111ind
plsql logic By: yashi7777 on Fri, 16 August 2019	10	4482	Sat, 17 August 2019 10:23 By: Michel Cadot
Data spliting 11gr2 By: rajeshkr on Mon, 12 August 2019	5	3818	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	3858	Fri, 16 August 2019 06:22 By: Bill B
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019	18	7697	Fri, 16 August 2019 05:50 By: Bill B
REQEXP_SUBTR debug 11i By: Mani Balan on Thu, 08 August 2019	3	3159	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	3040	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	3803	Thu, 08 August 2019 00:38 By: Michel Cadot