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
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 2786 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 2334 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 1779 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 2263 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 2822 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 2403 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 6816 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 4394 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 6087 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 2944 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 4983 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 1913 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 2700 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 1768 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 5695 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 3947 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 2078 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 2495 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 6165 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 2683 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 3204 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 2573 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 8484 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 2700 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 1831 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 2444 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 3809 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 1831 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 2139 Tue, 14 August 2018 15:07
By: vharish006
  Split Data in Column & Split Data in Excel (merged)
Excel 2016
By: vharish006 on Mon, 13 August 2018
7 2633 Mon, 13 August 2018 13:53
By: vharish006
  How to Convert Row to Column As Below
Oracle 11g
By: sonudev on Mon, 13 August 2018
11 2785 Mon, 13 August 2018 08:11
By: joy_division
  Dbms_metadat
12c
By: Kannan Oracle on Fri, 10 August 2018
2 2003 Fri, 10 August 2018 07:42
By: joy_division
  Spool Japanese Characters
Oracle 11g
By: pratyush_biswas on Thu, 09 August 2018
4 2859 Fri, 10 August 2018 07:05
By: Bill B
  PL/SQL Collection
Oracle 11G
By: RaShi.Raj on Thu, 09 August 2018
4 2212 Thu, 09 August 2018 06:43
By: poojagarg
  Get Record Count
Oracle 11g
By: lokimisc on Mon, 06 August 2018
9 4184 Thu, 09 August 2018 04:19
By: pablolee
  Back fill records
Oracle 11.2.0.3
By: pointers on Wed, 08 August 2018
4 2109 Wed, 08 August 2018 14:26
By: Solomon Yakobson
  Create JSON from SQL 12C R1
By: Manoj.Gupta.91 on Mon, 30 July 2018
10 4065 Tue, 31 July 2018 12:36
By: Solomon Yakobson
  OR clause degrades performance of a query?
Oracle database, any, Linux
By: raresn on Mon, 30 July 2018
2 2312 Mon, 30 July 2018 08:31
By: raresn
  Performance of Stored Programs
Oracle 12c , Linux
By: ninan on Sun, 29 July 2018
14 4087 Mon, 30 July 2018 03:02
By: Michel Cadot
  return top 10 records based on dynamic count of prev records results
oracle 11
By: greenwaldliron on Sun, 29 July 2018
7 3206 Sun, 29 July 2018 09:23
By: greenwaldliron
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 Nov 17 18:05:04 CST 2019