Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 6513 Sat, 05 October 2019 06:52
By: hissam78
  ORA-29279: SMTP permanent error: 550 domain.
Oracle DB, v.11.2.0.4
By: oralover2006 on Thu, 03 October 2019
6 3199 Fri, 04 October 2019 05:26
By: oralover2006
  How do I ignore row giving error?
Oracle 12c
By: Buchas on Fri, 04 October 2019
3 2927 Fri, 04 October 2019 04:00
By: cookiemonster
  question on using materialized view that will be based on table having billions of rows
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: wtolentino on Thu, 03 October 2019
2 2496 Fri, 04 October 2019 02:43
By: John Watson
  Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged)
Oracle DB, v.11.2.0.4
By: oralover2006 on Thu, 03 October 2019
8 2885 Thu, 03 October 2019 23:40
By: oralover2006
  Co-related Subquery Throwing Error While Using rank function
By: chavva.kiru@gmail.com on Tue, 01 October 2019
6 2953 Wed, 02 October 2019 09:54
By: Solomon Yakobson
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 4163 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 5267 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 4154 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 3940 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 2399 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 3149 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 2433 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 2111 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 3183 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 3802 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 3863 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 5096 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 3537 Tue, 17 September 2019 08:50
By: rajeshkr
  data masking
Oracle 12c 2
By: sss111ind on Thu, 12 September 2019
6 2544 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 2333 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2251 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 3618 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 3740 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 3796 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 4705 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 1424 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 1645 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 14071 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 4723 Wed, 04 September 2019 06:40
By: EdStevens
  ORA-04068: existing state of packages has been discarded
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat
By: fixxxer on Fri, 30 August 2019
4 4295 Mon, 02 September 2019 05:24
By: fixxxer
  How to remove ordinal suffixes after the numbers
pl/sql developer, windows 10
By: nareshk00 on Thu, 29 August 2019
10 4324 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 10712 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 2186 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 3036 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 4229 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 5078 Wed, 28 August 2019 00:33
By: Michel Cadot
icon5.gif 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 4722 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 4443 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 3545 Wed, 21 August 2019 14:58
By: Michel Cadot
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Fri Sep 25 10:14:16 CDT 2020