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
  DBMS_SCHEDULER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: chat2raj.s on Tue, 16 October 2018
4 861 Tue, 16 October 2018 07:23
By: John Watson
  Recursive query
By: zhaoquer on Tue, 16 October 2018
8 1015 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 1692 Mon, 15 October 2018 14:33
By: Bill B
  Convert Date in String field (merged)
By: ssmith001 on Tue, 18 September 2018
21 2805 Mon, 15 October 2018 14:09
By: Bill B
  Help with bitmap join indexes
11g
By: Paul Newman on Mon, 08 October 2018
2 1141 Mon, 15 October 2018 10:39
By: Bill B
  Duplicating Excel COUPNCD function in PLSQL.
By: SATHISHENU on Tue, 04 September 2018
9 1631 Sun, 14 October 2018 12:48
By: Barbara Boehmer
  Calculate problem , help me
By: zhaoquer on Sat, 13 October 2018
11 1146 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 1072 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 1525 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 710 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 2169 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 968 Tue, 09 October 2018 16:42
By: BlackSwan
  Help required on assigning value to Tabletype variable!
By: ramya29p on Tue, 09 October 2018
5 1032 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 862 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 1199 Mon, 08 October 2018 04:28
By: sanjeev.sharda
  Assign same Group id to rows
By: purnima1 on Sat, 06 October 2018
3 808 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 1193 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 895 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 896 Thu, 04 October 2018 06:54
By: wtolentino
  Creating a function
Oracle 11g
By: Odigitrium on Sat, 22 September 2018
6 1147 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 2354 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 891 Sat, 29 September 2018 15:52
By: Littlefoot
  Query for Matching Record --> as much matches
By: myclassic on Thu, 27 September 2018
12 1242 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 825 Thu, 27 September 2018 11:27
By: ssmith001
  Create collection of nested table
By: purnima1 on Wed, 26 September 2018
8 1306 Wed, 26 September 2018 09:21
By: purnima1
  In Class with sub query
By: nagaraju.ch on Tue, 25 September 2018
3 1136 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 806 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 882 Mon, 24 September 2018 06:05
By: msol25
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 822 Sat, 22 September 2018 14:29
By: Solomon Yakobson
  OE SAMPEL SCHEMA
ORACLE 12.2.0.1.0, window 10
By: Bilal Khan on Thu, 20 September 2018
22 1160 Thu, 20 September 2018 09:48
By: BlackSwan
  Help w/ REGEXP_SUBSTR
By: ssmith001 on Thu, 06 September 2018
26 2730 Tue, 18 September 2018 11:02
By: ssmith001
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 1393 Tue, 18 September 2018 09:10
By: JPBoileau
  Adding rownum in pagination query in oralce 12c
Oracle 12c
By: sss111ind on Sat, 15 September 2018
8 998 Mon, 17 September 2018 04:00
By: Michel Cadot
  Error in PL/SQL package function (table of records)
11.1.2.10
By: OraFerro on Sun, 16 September 2018
2 868 Mon, 17 September 2018 00:23
By: OraFerro
  Processed time for a Job SQL
11G
By: s.m.ramachandran on Fri, 14 September 2018
5 1072 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 1081 Wed, 12 September 2018 04:06
By: Michel Cadot
  Help in Understanding a complex (complex at least for me) sql to solve sudoku
11.2.04
By: orausern on Sat, 08 September 2018
3 1014 Sun, 09 September 2018 09:03
By: Solomon Yakobson
  update column on same table using database trigger
By: mist598 on Thu, 06 September 2018
27 1978 Fri, 07 September 2018 09:25
By: Bill B
  Help in YIELD [Excel Function] formula in PLSQL
Oracle 11 G
By: SATHISHENU on Mon, 27 November 2017
6 2359 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 3206 Sat, 01 September 2018 20:53
By: Barbara Boehmer
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 Nov 16 07:48:39 CST 2018