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
  Creating a function
Oracle 11g
By: Odigitrium on Sat, 22 September 2018
6 2289 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 6494 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 2075 Sat, 29 September 2018 15:52
By: Littlefoot
  Query for Matching Record --> as much matches
By: myclassic on Thu, 27 September 2018
12 2570 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 1969 Thu, 27 September 2018 11:27
By: ssmith001
  Create collection of nested table
By: purnima1 on Wed, 26 September 2018
8 2409 Wed, 26 September 2018 09:21
By: purnima1
  In Class with sub query
By: nagaraju.ch on Tue, 25 September 2018
3 1989 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 1809 Tue, 25 September 2018 13:01
By: wtolentino
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 1903 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 3680 Thu, 20 September 2018 09:48
By: BlackSwan
  Help w/ REGEXP_SUBSTR
By: ssmith001 on Thu, 06 September 2018
26 7195 Tue, 18 September 2018 11:02
By: ssmith001
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 2465 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 2026 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 1547 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 1996 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 2425 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 2037 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 6159 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 3887 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 5188 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 2477 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 4496 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 1670 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 2295 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 1507 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 5165 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 3564 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 1798 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 2164 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 5386 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 2267 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 2779 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 2193 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 7648 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 2276 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 1561 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 2075 Thu, 16 August 2018 10:34
By: Michel Cadot
icon5.gif failing in Creation of PL/SQL function
PL SQL ORACLE
By: bench on Wed, 15 August 2018
14 3285 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 1556 Wed, 15 August 2018 06:24
By: akash123
  XML Special Character
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 14 August 2018
0 1869 Tue, 14 August 2018 15:07
By: vharish006
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: Wed Aug 21 10:51:41 CDT 2019