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
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
41 179357 Thu, 23 July 2015 10:23
By: Lalit Kumar B
  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
0 2 Tue, 25 September 2018 07:41
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 280 Mon, 24 September 2018 06:05
By: msol25
  SQL code syntax Understanding
By: anirdesh on Sat, 22 September 2018
3 183 Sat, 22 September 2018 14:29
By: Solomon Yakobson
  Creating a function
Oracle 11g
By: Odigitrium on Sat, 22 September 2018
4 208 Sat, 22 September 2018 07:48
By: John Watson
  PL/SQL: could not find program unit being called when calling packages
By: venki8286 on Wed, 19 September 2018
31 663 Fri, 21 September 2018 15:20
By: EdStevens
  Cast to index by table
By: purnima1 on Fri, 21 September 2018
3 210 Fri, 21 September 2018 01:26
By: _jum
  OE SAMPEL SCHEMA
ORACLE 12.2.0.1.0, window 10
By: Bilal Khan on Thu, 20 September 2018
22 358 Thu, 20 September 2018 09:48
By: BlackSwan
  Convert Date in String field (merged)
By: ssmith001 on Tue, 18 September 2018
8 352 Wed, 19 September 2018 12:42
By: JPBoileau
  query performance
EBS R12, db-10.1.1.2
By: annu-agi on Wed, 19 September 2018
7 280 Wed, 19 September 2018 03:24
By: Michel Cadot
  Help w/ REGEXP_SUBSTR
By: ssmith001 on Thu, 06 September 2018
26 1421 Tue, 18 September 2018 11:02
By: ssmith001
  Time difference between 2 rows
oracle 12c
By: azeem87 on Wed, 12 September 2018
10 666 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 392 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 317 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 488 Fri, 14 September 2018 08:14
By: Solomon Yakobson
  String Comparison
Oracle 12.2 Windows
By: Duane on Tue, 11 September 2018
9 470 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 427 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 866 Fri, 07 September 2018 09:25
By: Bill B
  Duplicating Excel COUPNCD function in PLSQL.
By: SATHISHENU on Tue, 04 September 2018
8 471 Tue, 04 September 2018 03:46
By: John Watson
  Help in YIELD [Excel Function] formula in PLSQL
Oracle 11 G
By: SATHISHENU on Mon, 27 November 2017
6 1731 Tue, 04 September 2018 01:14
By: Michel Cadot
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
13 2491 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 561 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 632 Fri, 31 August 2018 11:36
By: Solomon Yakobson
  Error using API
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Thu, 30 August 2018
3 357 Thu, 30 August 2018 17:48
By: BlackSwan
  Error in converting CLOB to BLOB
SQL*Plus: Release 11.2.0.1.0
By: vinodkumarn on Mon, 27 August 2018
4 475 Mon, 27 August 2018 22:11
By: vinodkumarn
  Oracle regular expressions query
Oracle 11.2.0.2.0
By: jackman1 on Thu, 23 August 2018
2 629 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 713 Thu, 23 August 2018 11:55
By: cookiemonster
  find circular reference in data
By: purnima1 on Thu, 23 August 2018
4 531 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 1090 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 920 Tue, 21 August 2018 08:02
By: quirks
  Relation between two gold
By: purnima1 on Tue, 21 August 2018
3 536 Tue, 21 August 2018 07:15
By: Michel Cadot
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
9 765 Tue, 21 August 2018 07:13
By: Michel Cadot
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 1513 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 780 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 1391 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 856 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 1788 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 846 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 693 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 728 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: Tue Sep 25 07:45:28 CDT 2018