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
  ORA-29279: SMTP permanent error: 550 domain.
Oracle DB, v.11.2.0.4
By: oralover2006 on Thu, 03 October 2019
6 3523 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 3274 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 2747 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 3120 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 3241 Wed, 02 October 2019 09:54
By: Solomon Yakobson
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 4416 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 5493 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 4413 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 4230 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 2564 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 3369 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 2611 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 2303 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 3440 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 4076 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 4519 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 5345 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 3791 Tue, 17 September 2019 08:50
By: rajeshkr
  data masking
Oracle 12c 2
By: sss111ind on Thu, 12 September 2019
6 2737 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 2525 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2397 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 3868 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 3989 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 4067 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 4897 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 1594 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 1948 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 14380 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 5258 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 4824 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 4610 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 11160 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 2382 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 3192 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 4516 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 5291 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 4931 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 4658 Fri, 23 August 2019 01:59
By: vippysharma
  Bursting Program is not being Submitted
By: vharish006 on Wed, 21 August 2019
1 3699 Wed, 21 August 2019 14:58
By: Michel Cadot
  regexp_replace
Oracle 12c
By: sss111ind on Fri, 16 August 2019
6 3276 Tue, 20 August 2019 01:50
By: sss111ind
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: Thu Jan 21 19:05:51 CST 2021