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
  Query Not giving Proper Output and How to write Query In effective way
By: chavva.kiru@gmail.com on Thu, 03 October 2019
2 3709 Tue, 08 October 2019 04:06
By: flyboy
  Aggregate operation on array - get totals
11.2.0.1.0
By: OraFerro on Thu, 12 September 2019
5 6559 Tue, 08 October 2019 03:51
By: OraFerro
  display Old value and new value as per date in single row
By: suji6281 on Thu, 03 October 2019
1 3201 Mon, 07 October 2019 07:11
By: Bill B
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 9914 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 8357 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 4678 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 3945 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 4638 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 5317 Wed, 02 October 2019 09:54
By: Solomon Yakobson
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 5722 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 7481 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 6403 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 6015 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 3906 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 5363 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 4135 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 3979 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 5074 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 6737 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 8774 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 7037 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 5008 Tue, 17 September 2019 08:50
By: rajeshkr
  data masking
Oracle 12c 2
By: sss111ind on Thu, 12 September 2019
6 4519 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 3667 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 3541 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 6417 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 5957 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 5904 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 6712 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 2734 Mon, 09 September 2019 14:14
By: fabissilva
  BI Publisher Apex web Services
Oracle 11g
By: akarra on Mon, 09 September 2019
1 3800 Mon, 09 September 2019 12:59
By: akarra
  IIF and Oracle
Windows 2003 and Oracle 10g
By: aijaz786 on Thu, 18 February 2010
16 17342 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 8206 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 6903 Fri, 30 August 2019 13:47
By: nareshk00
  Purging Data From table!
By: ramya29p on Thu, 04 July 2019
22 15281 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 3564 Thu, 29 August 2019 11:45
By: wtolentino
  Create table as select
Oracle 11.2, AIX
By: corina on Wed, 28 August 2019
6 4653 Thu, 29 August 2019 10:38
By: Michel Cadot
  help with sql grouping
By: ramkumar10 on Thu, 10 August 2017
6 5850 Wed, 28 August 2019 17:01
By: ramkumar10
  Help with sql using analytical functions.
By: ramkumar10 on Thu, 22 August 2019
4 6482 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 6072 Fri, 23 August 2019 09:12
By: Bill B
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: Sun Mar 26 04:22:27 CDT 2023