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
  In SEND EMAIL code, how to remove Boundaries from the output
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: rappaj on Fri, 11 October 2019
32 13392 Wed, 04 December 2019 14:43
By: Michel Cadot
  Run Oracle SQL query multiple times with change in filter condition
12c
By: vsaenath on Mon, 02 December 2019
6 3781 Tue, 03 December 2019 10:38
By: flyboy
  Want to know insert into
By: kabina on Sat, 30 November 2019
3 2897 Sun, 01 December 2019 20:13
By: kabina
  Finding Date Pattern using LEAD
Oracle 12c
By: samiran_cts on Sun, 01 December 2019
8 3415 Sun, 01 December 2019 13:51
By: samiran_cts
  date format
SQL Developer
By: kabina on Wed, 27 November 2019
6 3899 Sat, 30 November 2019 08:05
By: EdStevens
  how to make table query in oracle (4 merged)
4.0.1.14
By: kabina on Wed, 27 November 2019
12 4999 Sat, 30 November 2019 02:11
By: John Watson
  ORA 01847
By: Satran on Wed, 27 November 2019
10 4055 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 7482 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 5663 Mon, 25 November 2019 05:39
By: nitesh.erp@gmail.com
  question for reverse
oracle 11g
By: manoj12 on Mon, 11 November 2019
6 5561 Fri, 22 November 2019 10:39
By: Bill B
  Record Plus Prior Record - Single Row
By: GIL149 on Fri, 15 November 2019
4 4886 Mon, 18 November 2019 10:00
By: JPBoileau
  Query performance condundrum.
Oracle 12c Linux
By: uman2631 on Fri, 15 November 2019
6 4196 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 5532 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 5993 Fri, 15 November 2019 10:22
By: Bill B
  problem to show result in join tables
By: hassan08 on Sat, 09 November 2019
14 6616 Wed, 13 November 2019 11:21
By: Michel Cadot
  Ajuda com procedure Type Pipilined
Oracle
By: cristine_katia on Mon, 11 November 2019
13 6053 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 7094 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 5662 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 5232 Fri, 01 November 2019 05:04
By: cookiemonster
  ANALYZE TABLE STATEMENT
19C, WINDOW
By: Bilal Khan on Sat, 26 October 2019
11 6758 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 4163 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 3663 Thu, 24 October 2019 11:13
By: Bill B
  Two digit decimal
By: Satya.tanmay on Wed, 23 October 2019
6 3767 Thu, 24 October 2019 08:46
By: Solomon Yakobson
  Exist Value in a table
12c
By: deepakdot on Fri, 18 October 2019
8 5202 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 2523 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 4711 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 4357 Sun, 20 October 2019 03:30
By: Shiv93
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 6684 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 5856 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 7748 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 3651 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 3534 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 9067 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 2516 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 3714 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 3651 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 2597 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 5010 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 2155 Mon, 07 October 2019 07:11
By: Bill B
  Calculation
Oracle 10G, Windows 2012R2
By: hissam78 on Thu, 26 September 2019
13 6914 Sat, 05 October 2019 06:52
By: hissam78
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: Fri Jan 22 10:52:00 CST 2021