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
  how to make table query in oracle (4 merged)
4.0.1.14
By: kabina on Wed, 27 November 2019
12 10061 Sat, 30 November 2019 02:11
By: John Watson
  ORA 01847
By: Satran on Wed, 27 November 2019
10 9067 Fri, 29 November 2019 09:08
By: cookiemonster
  bulk collect problem through dblink
Orale 12c, 12.1.0.2.0
By: mape on Sat, 23 November 2019
30 15633 Fri, 29 November 2019 07:22
By: Bill B
  Break line as per required attached output.
Oracle 11i
By: nitesh.erp@gmail.com on Sat, 23 November 2019
16 10033 Mon, 25 November 2019 05:39
By: nitesh.erp@gmail.com
  question for reverse
oracle 11g
By: manoj12 on Mon, 11 November 2019
6 8684 Fri, 22 November 2019 10:39
By: Bill B
  Record Plus Prior Record - Single Row
By: GIL149 on Fri, 15 November 2019
4 8104 Mon, 18 November 2019 10:00
By: JPBoileau
  Query performance condundrum.
Oracle 12c Linux
By: uman2631 on Fri, 15 November 2019
6 7820 Sat, 16 November 2019 11:41
By: John Watson
  Return TYpe (tablet) as output parameters.
Oracle
By: cristine_katia on Wed, 13 November 2019
7 9592 Fri, 15 November 2019 16:58
By: BlackSwan
icon5.gif who called my procedure through a database link
Oracle 10g
By: Bill B on Tue, 12 November 2019
8 9207 Fri, 15 November 2019 10:22
By: Bill B
  problem to show result in join tables
By: hassan08 on Sat, 09 November 2019
14 10206 Wed, 13 November 2019 11:21
By: Michel Cadot
  Ajuda com procedure Type Pipilined
Oracle
By: cristine_katia on Mon, 11 November 2019
13 10580 Tue, 12 November 2019 05:45
By: flyboy
  AWR Report SQL with Bind Variables
Oracle Version 12.1
By: kohila on Thu, 31 October 2019
8 12198 Wed, 06 November 2019 02:49
By: cookiemonster
  ALTER TABLE STATEMENT FOR CLUSTER
Oracle 19C/Window 10
By: Bilal Khan on Fri, 01 November 2019
7 8890 Sat, 02 November 2019 01:25
By: Michel Cadot
  Update null value columns based upon previous non null columns
11.2
By: lott42_gmail on Thu, 31 October 2019
8 8660 Fri, 01 November 2019 05:04
By: cookiemonster
  ANALYZE TABLE STATEMENT
19C, WINDOW
By: Bilal Khan on Sat, 26 October 2019
11 10040 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 6544 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 6180 Thu, 24 October 2019 11:13
By: Bill B
  Two digit decimal
By: Satya.tanmay on Wed, 23 October 2019
6 6778 Thu, 24 October 2019 08:46
By: Solomon Yakobson
  Exist Value in a table
12c
By: deepakdot on Fri, 18 October 2019
8 8150 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 4550 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 9231 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 8869 Sun, 20 October 2019 03:30
By: Shiv93
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 9093 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 9194 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 11087 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 7487 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 6156 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 16960 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 4419 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 5556 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 5886 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 4429 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 7420 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 3920 Mon, 07 October 2019 07:11
By: Bill B
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 11069 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 11510 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 5488 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 4693 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 5604 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 6321 Wed, 02 October 2019 09:54
By: Solomon Yakobson
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 18 07:28:56 CDT 2024