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
  Calling an API from PL/SQL
Oracle 12c RDS
By: Shiv93 on Thu, 10 October 2019
5 4226 Sun, 20 October 2019 03:30
By: Shiv93
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 6537 Tue, 15 October 2019 16:38
By: Amine
icon11.gif Why calculated a later invalid statement in a case-when after first true clause found?
PL/SQL Developer 11.0.6.1776 01.108073
By: Arthurbaa on Mon, 14 October 2019
14 5672 Tue, 15 October 2019 11:58
By: Michel Cadot
  Oracle - path passing by multiple nodes
oracle 12c
By: ghostman on Thu, 10 October 2019
18 7546 Tue, 15 October 2019 02:21
By: ghostman
  ORA-02315: Incorrect number of arguments for default constructor
SQLPLUS Oracle database 11g express edition 11.2.0.2.0 64bit
By: bo on Mon, 14 October 2019
2 3428 Mon, 14 October 2019 14:26
By: bo
  ORA-02320/ 00904 nested table error
SQLPLUS Oracle database 11g express edition 11.2.0.2.0 64bit
By: bo on Sun, 13 October 2019
4 3398 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 8632 Sat, 12 October 2019 09:14
By: EdStevens
  How To Measure Time To Build a Materialized View
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: wtolentino on Wed, 09 October 2019
2 2421 Wed, 09 October 2019 12:51
By: Michel Cadot
  How to get response from xml in oracle
oracle 11gR2
By: Ace Mirxa on Fri, 04 October 2019
3 3628 Tue, 08 October 2019 12:14
By: Bill B
  Factorial Function Confusing.
Oracle DB 10.2.0.4.0
By: mamalik on Mon, 07 October 2019
7 3544 Tue, 08 October 2019 09:04
By: JPBoileau
  Query Not giving Proper Output and How to write Query In effective way
By: chavva.kiru@gmail.com on Thu, 03 October 2019
2 2493 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 4913 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 2056 Mon, 07 October 2019 07:11
By: Bill B
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 6812 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 3353 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 3166 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 2660 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 2982 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 3074 Wed, 02 October 2019 09:54
By: Solomon Yakobson
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 4316 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 5401 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 4347 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 4144 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 2471 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 3240 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 2507 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 2191 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 3349 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 3964 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 4242 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 5241 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 3725 Tue, 17 September 2019 08:50
By: rajeshkr
  data masking
Oracle 12c 2
By: sss111ind on Thu, 12 September 2019
6 2671 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 2462 Thu, 12 September 2019 10:13
By: Michel Cadot
  what is utc and gmt
Oracle 12c
By: sss111ind on Wed, 11 September 2019
3 2345 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 3765 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 3893 Wed, 11 September 2019 07:14
By: ssyr
  display data in new column
By: getideas456@gmail.com on Fri, 06 September 2019
6 3974 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 4779 Tue, 10 September 2019 00:19
By: Michel Cadot
  Procedure SendMail Gmail
Oracle 11
By: fabissilva on Mon, 09 September 2019
0 1517 Mon, 09 September 2019 14:14
By: fabissilva
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: Sat Nov 28 20:26:15 CST 2020