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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 8295 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 217717 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  delete from table where one of the column is nested table is running long.
oracle
By: tdave2019 on Wed, 04 December 2019
7 809 Thu, 05 December 2019 02:44
By: cookiemonster
  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 6199 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 751 Tue, 03 December 2019 10:38
By: flyboy
  Want to know insert into
By: kabina on Sat, 30 November 2019
3 737 Sun, 01 December 2019 20:13
By: kabina
  Finding Date Pattern using LEAD
Oracle 12c
By: samiran_cts on Sun, 01 December 2019
8 614 Sun, 01 December 2019 13:51
By: samiran_cts
  date format
SQL Developer
By: kabina on Wed, 27 November 2019
6 1232 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 1435 Sat, 30 November 2019 02:11
By: John Watson
  ORA 01847
By: Satran on Wed, 27 November 2019
10 986 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 2719 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 1747 Mon, 25 November 2019 05:39
By: nitesh.erp@gmail.com
  question for reverse
oracle 11g
By: manoj12 on Mon, 11 November 2019
6 2433 Fri, 22 November 2019 10:39
By: Bill B
  Record Plus Prior Record - Single Row
By: GIL149 on Fri, 15 November 2019
4 2088 Mon, 18 November 2019 10:00
By: JPBoileau
  Query performance condundrum.
Oracle 12c Linux
By: uman2631 on Fri, 15 November 2019
6 1646 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 2754 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 3221 Fri, 15 November 2019 10:22
By: Bill B
  problem to show result in join tables
By: hassan08 on Sat, 09 November 2019
14 3839 Wed, 13 November 2019 11:21
By: Michel Cadot
  Ajuda com procedure Type Pipilined
Oracle
By: cristine_katia on Mon, 11 November 2019
13 2811 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 4242 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 2901 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 2683 Fri, 01 November 2019 05:04
By: cookiemonster
  ANALYZE TABLE STATEMENT
19C, WINDOW
By: Bilal Khan on Sat, 26 October 2019
11 3741 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 1883 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 2250 Thu, 24 October 2019 11:13
By: Bill B
  Two digit decimal
By: Satya.tanmay on Wed, 23 October 2019
6 1781 Thu, 24 October 2019 08:46
By: Solomon Yakobson
  Exist Value in a table
12c
By: deepakdot on Fri, 18 October 2019
8 3068 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 1143 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 1962 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 1978 Sun, 20 October 2019 03:30
By: Shiv93
  Rows into Columns (2 merged)
Oracle 10G, Windows 2012R2
By: hissam78 on Tue, 08 October 2019
10 4338 Wed, 16 October 2019 04:44
By: hissam78
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 4992 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 3456 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 4349 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 1670 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 1597 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 4641 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 1199 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 2288 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 1942 Tue, 08 October 2019 09:04
By: JPBoileau
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 Dec 06 04:52:18 CST 2019