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
  Create collection of nested table
By: purnima1 on Wed, 26 September 2018
8 3343 Wed, 26 September 2018 09:21
By: purnima1
  In Class with sub query
By: nagaraju.ch on Tue, 25 September 2018
3 2664 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 3033 Tue, 25 September 2018 13:01
By: wtolentino
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 2679 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 5884 Thu, 20 September 2018 09:48
By: BlackSwan
  Help w/ REGEXP_SUBSTR
By: ssmith001 on Thu, 06 September 2018
26 9278 Tue, 18 September 2018 11:02
By: ssmith001
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 3314 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 2797 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 2170 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 2703 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 3367 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 2953 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 7852 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 5183 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 7721 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 3603 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 5510 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 2359 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 3499 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 2178 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 6377 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 4507 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 2499 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 2943 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 6778 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 3385 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 3766 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 3123 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 9712 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 3252 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 2289 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 2989 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 4689 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 2254 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 2609 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 3161 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 3325 Mon, 13 August 2018 08:11
By: joy_division
  Dbms_metadat
12c
By: Kannan Oracle on Fri, 10 August 2018
2 2428 Fri, 10 August 2018 07:42
By: joy_division
  Spool Japanese Characters
Oracle 11g
By: pratyush_biswas on Thu, 09 August 2018
4 3539 Fri, 10 August 2018 07:05
By: Bill B
  PL/SQL Collection
Oracle 11G
By: RaShi.Raj on Thu, 09 August 2018
4 2661 Thu, 09 August 2018 06:43
By: poojagarg
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: Mon Jun 01 12:28:03 CDT 2020