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
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 3699 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 3048 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 2889 Thu, 04 October 2018 06:54
By: wtolentino
  Creating a function
Oracle 11g
By: Odigitrium on Sat, 22 September 2018
6 3997 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 9368 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 3555 Sat, 29 September 2018 15:52
By: Littlefoot
  Query for Matching Record --> as much matches
By: myclassic on Thu, 27 September 2018
12 4082 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 5319 Thu, 27 September 2018 11:27
By: ssmith001
  Create collection of nested table
By: purnima1 on Wed, 26 September 2018
8 4428 Wed, 26 September 2018 09:21
By: purnima1
  In Class with sub query
By: nagaraju.ch on Tue, 25 September 2018
3 3483 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 5194 Tue, 25 September 2018 13:01
By: wtolentino
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 3417 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 7947 Thu, 20 September 2018 09:48
By: BlackSwan
  Help w/ REGEXP_SUBSTR
By: ssmith001 on Thu, 06 September 2018
26 10438 Tue, 18 September 2018 11:02
By: ssmith001
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 4217 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 3747 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 2926 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 3613 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 4361 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 3846 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 10971 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 6566 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 10220 Sat, 01 September 2018 20:53
By: Barbara Boehmer
  Oracle ad-hoc report issues
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Wed, 29 August 2018
14 4650 Fri, 31 August 2018 11:58
By: buggleboy007
  Query to group data
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
By: fixxxer on Fri, 31 August 2018
14 6753 Fri, 31 August 2018 11:36
By: Solomon Yakobson
  Oracle regular expressions query
Oracle 11.2.0.2.0
By: jackman1 on Thu, 23 August 2018
2 3167 Thu, 23 August 2018 12:57
By: jackman1
  SQLException encounter while executing data trigger.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Mon, 20 August 2018
4 5406 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 3044 Thu, 23 August 2018 06:55
By: Solomon Yakobson
  consistency constraint ON store Procedure
12c, window
By: Bilal Khan on Tue, 21 August 2018
22 7673 Tue, 21 August 2018 08:52
By: Solomon Yakobson
  Running settlement of inward vs outward quantity
Oracle 11g
By: chintan.patel on Mon, 20 August 2018
13 5754 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 3431 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 3970 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 8213 Mon, 20 August 2018 10:01
By: JPBoileau
  Row Movement disabled in Partitioned table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sun, 19 August 2018
5 4877 Mon, 20 August 2018 06:30
By: Roachcoach
  Prevent Rounding when using Format Masking
Oracle 12.1.0.2.0, RHEL
By: abhi_orcl on Thu, 16 August 2018
6 5285 Fri, 17 August 2018 18:37
By: Solomon Yakobson
  Extracting just text from a Blob Column
11.2
By: dejah on Thu, 16 August 2018
5 4137 Fri, 17 August 2018 18:28
By: Solomon Yakobson
  SQL to Subtract X workdays from a date
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Wed, 15 August 2018
32 11277 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 4421 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 3103 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 3940 Thu, 16 August 2018 10:34
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: Sun Aug 01 08:08:28 CDT 2021