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
  Update null value columns based upon previous non null columns
11.2
By: lott42_gmail on Thu, 31 October 2019
8 5575 Fri, 01 November 2019 05:04
By: cookiemonster
  ANALYZE TABLE STATEMENT
19C, WINDOW
By: Bilal Khan on Sat, 26 October 2019
11 7100 Sat, 26 October 2019 11:34
By: Bilal Khan
  Multiple Out Parameters Function in Select Statement - Oracle
Oracle 11.2.0.3.0
By: myclassic on Thu, 24 October 2019
5 4500 Fri, 25 October 2019 04:47
By: myclassic
  Cursor throwing error while passing to dbms_stats.gather_schema_stats
By: chavva.kiru@gmail.com on Tue, 22 October 2019
3 3936 Thu, 24 October 2019 11:13
By: Bill B
  Two digit decimal
By: Satya.tanmay on Wed, 23 October 2019
6 4074 Thu, 24 October 2019 08:46
By: Solomon Yakobson
  Exist Value in a table
12c
By: deepakdot on Fri, 18 October 2019
8 5473 Wed, 23 October 2019 02:39
By: deepakdot
  Help with questions i'm tying to validate from interview
SQL newest version
By: jricks on Mon, 21 October 2019
1 2790 Mon, 21 October 2019 22:21
By: BlackSwan
  Interval Partition table on Date column with SYSDATE as value (merged)
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: revathitirun on Mon, 21 October 2019
6 5117 Mon, 21 October 2019 04:31
By: revathitirun
  Calling an API from PL/SQL
Oracle 12c RDS
By: Shiv93 on Thu, 10 October 2019
5 4703 Sun, 20 October 2019 03:30
By: Shiv93
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 6969 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 6187 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 8196 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 4179 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 3849 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 9872 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 2777 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 3967 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 3957 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 2861 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 5322 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 2417 Mon, 07 October 2019 07:11
By: Bill B
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 7236 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 3901 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 3531 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 3004 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 3447 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 3541 Wed, 02 October 2019 09:54
By: Solomon Yakobson
  running total query
11 g
By: annu-agi on Sat, 21 September 2019
4 4674 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 5767 Mon, 30 September 2019 05:49
By: Bill B
  date usage in SQL query
By: James1116 on Mon, 23 September 2019
6 4688 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 4496 Fri, 27 September 2019 08:48
By: rappaj
  SQL to find Consecutive Halves
By: patneel on Tue, 24 September 2019
2 2830 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 3669 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 2863 Wed, 25 September 2019 03:31
By: Michel Cadot
  display issue
By: James1116 on Tue, 24 September 2019
4 2569 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 3722 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 4385 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 5202 Fri, 20 September 2019 06:39
By: revathitirun
  getting informations about processes
Oracle 11 - Unix
By: limner1977 on Thu, 12 September 2019
13 5669 Tue, 17 September 2019 10:35
By: limner1977
  help around LIST_AGG function
oracle 11gr2
By: rajeshkr on Fri, 13 September 2019
4 4082 Tue, 17 September 2019 08:50
By: rajeshkr
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 May 08 20:32:43 CDT 2021