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
RETURNING clause returns wrong value upon UPDATE statement Oracle 11g By: ermoadam on Mon, 23 September 2019	5	5734	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	7593	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	10478	Fri, 20 September 2019 06:39 By: revathitirun
getting informations about processes Oracle 11 - Unix By: limner1977 on Thu, 12 September 2019	13	7878	Tue, 17 September 2019 10:35 By: limner1977
help around LIST_AGG function oracle 11gr2 By: rajeshkr on Fri, 13 September 2019	4	5660	Tue, 17 September 2019 08:50 By: rajeshkr
data masking Oracle 12c 2 By: sss111ind on Thu, 12 September 2019	6	5178	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	4298	Thu, 12 September 2019 10:13 By: Michel Cadot
what is utc and gmt Oracle 12c By: sss111ind on Wed, 11 September 2019	3	4186	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	7258	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	6865	Wed, 11 September 2019 07:14 By: ssyr
display data in new column By: getideas456@gmail.com on Fri, 06 September 2019	6	6732	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	7392	Tue, 10 September 2019 00:19 By: Michel Cadot
Procedure SendMail Gmail Oracle 11 By: fabissilva on Mon, 09 September 2019	0	3374	Mon, 09 September 2019 14:14 By: fabissilva
BI Publisher Apex web Services Oracle 11g By: akarra on Mon, 09 September 2019	1	4591	Mon, 09 September 2019 12:59 By: akarra
IIF and Oracle Windows 2003 and Oracle 10g By: aijaz786 on Thu, 18 February 2010	16	18354	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	9793	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	7693	Fri, 30 August 2019 13:47 By: nareshk00
Purging Data From table! By: ramya29p on Thu, 04 July 2019	22	16658	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	4225	Thu, 29 August 2019 11:45 By: wtolentino
Create table as select Oracle 11.2, AIX By: corina on Wed, 28 August 2019	6	5307	Thu, 29 August 2019 10:38 By: Michel Cadot
help with sql grouping By: ramkumar10 on Thu, 10 August 2017	6	6616	Wed, 28 August 2019 17:01 By: ramkumar10
Help with sql using analytical functions. By: ramkumar10 on Thu, 22 August 2019	4	7156	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	6788	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	6417	Fri, 23 August 2019 01:59 By: vippysharma
Bursting Program is not being Submitted By: vharish006 on Wed, 21 August 2019	1	5475	Wed, 21 August 2019 14:58 By: Michel Cadot
regexp_replace Oracle 12c By: sss111ind on Fri, 16 August 2019	6	4928	Tue, 20 August 2019 01:50 By: sss111ind
xml generation from db Oracle 12c 2 By: sss111ind on Wed, 14 August 2019	1	3663	Mon, 19 August 2019 03:47 By: sss111ind
plsql logic By: yashi7777 on Fri, 16 August 2019	10	6074	Sat, 17 August 2019 10:23 By: Michel Cadot
Data spliting 11gr2 By: rajeshkr on Mon, 12 August 2019	5	4803	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	5121	Fri, 16 August 2019 06:22 By: Bill B
SQL Tuning instead of Cross Join 11G By: laknar on Thu, 25 July 2019	18	9218	Fri, 16 August 2019 05:50 By: Bill B
REQEXP_SUBTR debug 11i By: Mani Balan on Thu, 08 August 2019	3	4207	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	4180	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	5288	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	7684	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	10826	Tue, 06 August 2019 12:57 By: Michel Cadot
Oracle insert statement Oracle 12 By: anand.doss on Sat, 03 August 2019	2	4258	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	7277	Mon, 05 August 2019 03:00 By: cookiemonster
Convert Columns to rows win 8,Oracle 10g By: Xandot on Thu, 20 November 2014	7	6230	Tue, 30 July 2019 02:56 By: Michel Cadot
Leading zeros in a spool file By: Mike Bentley on Wed, 20 December 2006	6	11871	Mon, 29 July 2019 09:00 By: Bill B