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
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
41 182655 Thu, 23 July 2015 10:23
By: Lalit Kumar B
  Pulling hair out trying to use table function
Oracle 11
By: jbarker36 on Fri, 12 October 2018
16 740 Tue, 16 October 2018 13:44
By: JPBoileau
  Written Assignment-Printing a Record Using an If Statement
By: cwilliam912 on Sun, 14 October 2018
19 937 Tue, 16 October 2018 13:33
By: cwilliam912
  DR Failure
By: msyogi on Tue, 16 October 2018
6 283 Tue, 16 October 2018 08:58
By: joy_division
  Count of Pending, Failed, Running, Completed records
Oracle 12c
By: user_5678 on Mon, 15 October 2018
7 573 Tue, 16 October 2018 08:02
By: EdStevens
  DBMS_SCHEDULER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: chat2raj.s on Tue, 16 October 2018
4 249 Tue, 16 October 2018 07:23
By: John Watson
  redundant output
By: suji6281 on Tue, 16 October 2018
8 317 Tue, 16 October 2018 07:01
By: suji6281
  Recursive query
By: zhaoquer on Tue, 16 October 2018
8 315 Tue, 16 October 2018 06:40
By: zhaoquer
  Rownumer WITH OUT Order by
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 29 September 2018
13 1078 Mon, 15 October 2018 14:33
By: Bill B
  Convert Date in String field (merged)
By: ssmith001 on Tue, 18 September 2018
21 1833 Mon, 15 October 2018 14:09
By: Bill B
  Help with bitmap join indexes
11g
By: Paul Newman on Mon, 08 October 2018
2 608 Mon, 15 October 2018 10:39
By: Bill B
  Duplicating Excel COUPNCD function in PLSQL.
By: SATHISHENU on Tue, 04 September 2018
9 1049 Sun, 14 October 2018 12:48
By: Barbara Boehmer
  Calculate problem , help me
By: zhaoquer on Sat, 13 October 2018
11 668 Sat, 13 October 2018 04:01
By: zhaoquer
icon4.gif Complex SQL Quiries for me
11g,12c
By: graphe on Fri, 12 October 2018
6 592 Fri, 12 October 2018 16:18
By: pablolee
  Error in converting CLOB to BLOB
SQL*Plus: Release 11.2.0.1.0
By: vinodkumarn on Mon, 27 August 2018
6 1008 Fri, 12 October 2018 11:55
By: vinodkumarn
  Return Rows when no data exists
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Wed, 10 October 2018
2 304 Wed, 10 October 2018 15:53
By: John Watson
  TRIM function
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: wtolentino on Wed, 10 October 2018
3 1791 Wed, 10 October 2018 09:17
By: wtolentino
  https://community.oracle.com/message/14958599#14958599
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: suhaas on Tue, 09 October 2018
1 556 Tue, 09 October 2018 16:42
By: BlackSwan
  Help required on assigning value to Tabletype variable!
By: ramya29p on Tue, 09 October 2018
5 631 Tue, 09 October 2018 08:22
By: Solomon Yakobson
  How to merge 2 rows from a table to 1 row (2 columns)
By: dsslim on Mon, 08 October 2018
2 525 Mon, 08 October 2018 20:58
By: dsslim
  HELP NEEDED IN COMPILING PACKAGE
ORACLE 11 G
By: sanjeev.sharda on Thu, 04 October 2018
7 828 Mon, 08 October 2018 04:28
By: sanjeev.sharda
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
3 486 Sat, 06 October 2018 07:54
By: Michel Cadot
icon5.gif How to read correctly the execution plan in oracle, both in tree and tabular mode?
By: TheMatrix on Thu, 04 October 2018
6 855 Sat, 06 October 2018 07:49
By: TheMatrix
  If the sting value more then 3 separated need to split into 2nd line
By: mist598 on Fri, 05 October 2018
4 558 Fri, 05 October 2018 07:26
By: Michel Cadot
  regular expression substring to get the string that is delimited by a comma
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: wtolentino on Wed, 03 October 2018
2 585 Thu, 04 October 2018 06:54
By: wtolentino
  Optimal Chunk size for update of 50M record table
Oracle 11g RAC, Linux OEL 6
By: Andrey_R on Wed, 03 October 2018
12 658 Wed, 03 October 2018 11:13
By: BlackSwan
  Last and Sum in group by
11.1.2.10
By: OraFerro on Thu, 27 September 2018
2 675 Mon, 01 October 2018 23:36
By: OraFerro
  Creating a function
Oracle 11g
By: Odigitrium on Sat, 22 September 2018
6 820 Mon, 01 October 2018 14:08
By: Solomon Yakobson
  PL/SQL: could not find program unit being called when calling packages
By: venki8286 on Wed, 19 September 2018
32 1763 Mon, 01 October 2018 08:57
By: Bill B
  Listing all dates in a date range
Oracle, 11g Release 2, Windows 7
By: Subrata05005 on Sat, 29 September 2018
5 567 Sat, 29 September 2018 15:52
By: Littlefoot
  Query for Matching Record --> as much matches
By: myclassic on Thu, 27 September 2018
12 895 Fri, 28 September 2018 04:59
By: myclassic
  Using LISTAGG in a subquery
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Thu, 27 September 2018
3 535 Thu, 27 September 2018 11:27
By: ssmith001
  Create collection of nested table
By: purnima1 on Wed, 26 September 2018
8 1011 Wed, 26 September 2018 09:21
By: purnima1
  In Class with sub query
By: nagaraju.ch on Tue, 25 September 2018
3 871 Wed, 26 September 2018 09:09
By: Roachcoach
  How to Find the Parent of Index Organized Table
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: wtolentino on Tue, 25 September 2018
6 696 Tue, 25 September 2018 13:01
By: wtolentino
  Writing Arabic Text using UTL_FILE
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
By: chat2raj.s on Mon, 24 September 2018
1 797 Mon, 24 September 2018 06:05
By: msol25
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 737 Sat, 22 September 2018 14:29
By: Solomon Yakobson
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
3 699 Fri, 21 September 2018 01:26
By: _jum
  OE SAMPEL SCHEMA
ORACLE 12.2.0.1.0, window 10
By: Bilal Khan on Thu, 20 September 2018
22 1032 Thu, 20 September 2018 09:48
By: BlackSwan
  query performance
EBS R12, db-10.1.1.2
By: annu-agi on Wed, 19 September 2018
7 819 Wed, 19 September 2018 03:24
By: Michel Cadot
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: Tue Oct 16 16:11:04 CDT 2018