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
  Materialized Views Cannot set with refresh Fast "Error"
Oracle 19
By: greatwhite on Mon, 09 December 2019
9 7425 Wed, 11 December 2019 05:58
By: Bill B
  How to Pass number value to a varchar field
By: asadkhan_2 on Mon, 09 December 2019
4 4564 Mon, 09 December 2019 11:18
By: Solomon Yakobson
  Rows into Columns (2 merged)
Oracle 10G, Windows 2012R2
By: hissam78 on Tue, 08 October 2019
11 11672 Mon, 09 December 2019 09:51
By: ramsql
  delete from table where one of the column is nested table is running long.
oracle
By: tdave2019 on Wed, 04 December 2019
7 7344 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 19779 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 6192 Tue, 03 December 2019 10:38
By: flyboy
  Want to know insert into
By: kabina on Sat, 30 November 2019
3 4552 Sun, 01 December 2019 20:13
By: kabina
  Finding Date Pattern using LEAD
Oracle 12c
By: samiran_cts on Sun, 01 December 2019
8 5949 Sun, 01 December 2019 13:51
By: samiran_cts
  date format
SQL Developer
By: kabina on Wed, 27 November 2019
6 6358 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 8736 Sat, 30 November 2019 02:11
By: John Watson
  ORA 01847
By: Satran on Wed, 27 November 2019
10 7603 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 13153 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 8853 Mon, 25 November 2019 05:39
By: nitesh.erp@gmail.com
  question for reverse
oracle 11g
By: manoj12 on Mon, 11 November 2019
6 7610 Fri, 22 November 2019 10:39
By: Bill B
  Record Plus Prior Record - Single Row
By: GIL149 on Fri, 15 November 2019
4 7055 Mon, 18 November 2019 10:00
By: JPBoileau
  Query performance condundrum.
Oracle 12c Linux
By: uman2631 on Fri, 15 November 2019
6 6680 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 8398 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 8094 Fri, 15 November 2019 10:22
By: Bill B
  problem to show result in join tables
By: hassan08 on Sat, 09 November 2019
14 9013 Wed, 13 November 2019 11:21
By: Michel Cadot
  Ajuda com procedure Type Pipilined
Oracle
By: cristine_katia on Mon, 11 November 2019
13 9318 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 10716 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 7811 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 7735 Fri, 01 November 2019 05:04
By: cookiemonster
  ANALYZE TABLE STATEMENT
19C, WINDOW
By: Bilal Khan on Sat, 26 October 2019
11 8959 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 5607 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 5206 Thu, 24 October 2019 11:13
By: Bill B
  Two digit decimal
By: Satya.tanmay on Wed, 23 October 2019
6 5794 Thu, 24 October 2019 08:46
By: Solomon Yakobson
  Exist Value in a table
12c
By: deepakdot on Fri, 18 October 2019
8 7215 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 3812 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 7281 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 7314 Sun, 20 October 2019 03:30
By: Shiv93
  Syhthesizing
11.2.0.3.0
By: Amine on Fri, 20 September 2019
7 8013 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 8005 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 9878 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 5985 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 5124 Sun, 13 October 2019 16:12
By: bo
  Error message: ORA-08103: object no longer exists.
By: abhilashrn on Tue, 08 October 2019
28 14621 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 3630 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 4816 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 5013 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: Sun Mar 26 03:40:37 CDT 2023