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
running total query 11 g By: annu-agi on Sat, 21 September 2019	4	6622	Mon, 30 September 2019 06:10 By: Bill B
Cannot drop a user oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM By: janakors on Sun, 15 September 2019	7	8431	Mon, 30 September 2019 05:49 By: Bill B
date usage in SQL query By: James1116 on Mon, 23 September 2019	6	7337	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	7177	Fri, 27 September 2019 08:48 By: rappaj
SQL to find Consecutive Halves By: patneel on Tue, 24 September 2019	2	4739	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	6244	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	5029	Wed, 25 September 2019 03:31 By: Michel Cadot
display issue By: James1116 on Tue, 24 September 2019	4	4867	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	5926	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	7779	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	10822	Fri, 20 September 2019 06:39 By: revathitirun
getting informations about processes Oracle 11 - Unix By: limner1977 on Thu, 12 September 2019	13	8056	Tue, 17 September 2019 10:35 By: limner1977
help around LIST_AGG function oracle 11gr2 By: rajeshkr on Fri, 13 September 2019	4	5841	Tue, 17 September 2019 08:50 By: rajeshkr
data masking Oracle 12c 2 By: sss111ind on Thu, 12 September 2019	6	5363	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	4468	Thu, 12 September 2019 10:13 By: Michel Cadot
what is utc and gmt Oracle 12c By: sss111ind on Wed, 11 September 2019	3	4356	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	7457	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	7064	Wed, 11 September 2019 07:14 By: ssyr
display data in new column By: getideas456@gmail.com on Fri, 06 September 2019	6	6930	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	7574	Tue, 10 September 2019 00:19 By: Michel Cadot
Procedure SendMail Gmail Oracle 11 By: fabissilva on Mon, 09 September 2019	0	3551	Mon, 09 September 2019 14:14 By: fabissilva
BI Publisher Apex web Services Oracle 11g By: akarra on Mon, 09 September 2019	1	4789	Mon, 09 September 2019 12:59 By: akarra
IIF and Oracle Windows 2003 and Oracle 10g By: aijaz786 on Thu, 18 February 2010	16	18547	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	10087	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	7880	Fri, 30 August 2019 13:47 By: nareshk00
Purging Data From table! By: ramya29p on Thu, 04 July 2019	22	16877	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	4418	Thu, 29 August 2019 11:45 By: wtolentino
Create table as select Oracle 11.2, AIX By: corina on Wed, 28 August 2019	6	5488	Thu, 29 August 2019 10:38 By: Michel Cadot
help with sql grouping By: ramkumar10 on Thu, 10 August 2017	6	6802	Wed, 28 August 2019 17:01 By: ramkumar10
Help with sql using analytical functions. By: ramkumar10 on Thu, 22 August 2019	4	7333	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	6970	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	6595	Fri, 23 August 2019 01:59 By: vippysharma
Bursting Program is not being Submitted By: vharish006 on Wed, 21 August 2019	1	5675	Wed, 21 August 2019 14:58 By: Michel Cadot
regexp_replace Oracle 12c By: sss111ind on Fri, 16 August 2019	6	5122	Tue, 20 August 2019 01:50 By: sss111ind
xml generation from db Oracle 12c 2 By: sss111ind on Wed, 14 August 2019	1	3828	Mon, 19 August 2019 03:47 By: sss111ind
plsql logic By: yashi7777 on Fri, 16 August 2019	10	6256	Sat, 17 August 2019 10:23 By: Michel Cadot
Data spliting 11gr2 By: rajeshkr on Mon, 12 August 2019	5	4985	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	5284	Fri, 16 August 2019 06:22 By: Bill B
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019	18	9393	Fri, 16 August 2019 05:50 By: Bill B
REQEXP_SUBTR debug 11i By: Mani Balan on Thu, 08 August 2019	3	4383	Tue, 13 August 2019 14:15 By: Michel Cadot