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
  Select columns based on first record (Header from flat file)
Oracle 11g, Windows 2012 R2
By: rahul1982 on Tue, 06 September 2016
20 1398 Wed, 07 September 2016 03:25
By: Michel Cadot
  Hierarchy view
Oracle Database 12c Standard Edition Release 12.1.0.2.0
By: steveshephard87 on Sat, 03 September 2016
2 531 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 614 Fri, 02 September 2016 07:22
By: EdStevens
  Selecting the columns
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 06 September 2016
32 1571 Fri, 04 November 2016 11:24
By: Solomon Yakobson
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 465 Wed, 31 August 2016 15:16
By: DivP
  select statement to split string as per the content and show it
oracle 11g, windows
By: chinmay89 on Wed, 31 August 2016
5 567 Mon, 05 September 2016 04:20
By: sandeep_orafaq
  Query to find special alphabets
Oracle 11g Release 2, Linux
By: anil_mk on Wed, 31 August 2016
5 583 Thu, 01 September 2016 06:33
By: Michel Cadot
  Help required in SQL Analytic Funciton
Oracle 11g 11.2.0.1.0
By: jimit_shaili on Wed, 31 August 2016
2 425 Wed, 31 August 2016 06:55
By: Michel Cadot
  Insert data into SYSTEM partitioned table using DB link
Oracle 11g Release 2, Linux
By: anil_mk on Tue, 30 August 2016
4 506 Wed, 31 August 2016 05:34
By: anil_mk
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 895 Wed, 31 August 2016 08:22
By: Michel Cadot
  Format result set of a union
DB 10g
By: adfnewbie on Mon, 29 August 2016
24 1102 Wed, 07 September 2016 03:56
By: sandeep_orafaq
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 539 Fri, 26 August 2016 02:43
By: glmjoy
  how to restrict set of data in oracle
oracle,12.1.0.2.0 ,windows7
By: saini006 on Thu, 25 August 2016
3 469 Thu, 25 August 2016 07:51
By: Michel Cadot
icon5.gif Union of 4 different columns in Single Row
SQL, PLSQL
By: anil_apps on Wed, 24 August 2016
4 532 Thu, 25 August 2016 00:44
By: Michel Cadot
  Query to get Middle Record from a table
Oracle 11g
By: arifs3738 on Wed, 24 August 2016
8 802 Thu, 25 August 2016 06:37
By: EdStevens
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 735 Fri, 26 August 2016 02:46
By: saipradyumn
  Sequence partition clause
DB12.x (and possibly earlier)
By: John Watson on Tue, 23 August 2016
2 512 Tue, 23 August 2016 03:15
By: John Watson
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 762 Fri, 26 August 2016 23:25
By: vickytalware
  Need to correlate and reconcile two data sets with different number of records
Oracle Database, 10g Rel.2 , Windows Server 2012
By: mazam on Mon, 22 August 2016
1 517 Mon, 22 August 2016 13:54
By: Barbara Boehmer
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 802 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 864 Fri, 19 August 2016 14:28
By: BlackSwan
  Insert the data into dynamically created table (2 threads merged by bb)
11.2.0.4
By: grpatwari on Thu, 18 August 2016
15 1222 Mon, 02 January 2017 23:20
By: grpatwari
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 539 Wed, 17 August 2016 14:04
By: Michel Cadot
  How to get a value that has never been updated
Oracle Database:11.2.0.1.0; TOAD: 12.1, O/S: Windows 7 Professional 64 bit
By: buggleboy007 on Wed, 17 August 2016
2 911 Wed, 17 August 2016 21:33
By: buggleboy007
  PL/SQL: ORA-00942: table or view does not exist
Oracle 11g, 11.2.0.3.0
By: wtolentino on Tue, 16 August 2016
3 772 Wed, 17 August 2016 06:45
By: wtolentino
  keep only numeric values in a string
oracle 11g, windows
By: chinmay45 on Tue, 16 August 2016
18 675 Wed, 17 August 2016 01:35
By: Michel Cadot
  Nested Query- Result Achieved. Performance improvement ?
10.2.0.1.0
By: bluetooth420 on Thu, 22 September 2016
19 1182 Sun, 25 September 2016 12:22
By: BlackSwan
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 672 Wed, 17 August 2016 06:28
By: Michel Cadot
  Renaming a table
Oracle 11
By: saipradyumn on Tue, 16 August 2016
6 604 Wed, 17 August 2016 07:28
By: Bill B
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 567 Thu, 25 August 2016 09:40
By: ALEXWE
  How to remove duplicate value from type in SQL
Oracle 11i,Toad
By: victoryhendry on Tue, 16 August 2016
6 1051 Mon, 22 August 2016 04:51
By: sandeep_orafaq
  Update or create function paramater
Oracle Database 10g Enterprise Edition ,10.2.0.4.0, linux64_86
By: abdo2203 on Sat, 13 August 2016
5 684 Sat, 13 August 2016 09:36
By: abdo2203
  Help reverse engineering pl sql query
Oracle sql
By: jprisk on Fri, 12 August 2016
4 645 Fri, 12 August 2016 15:03
By: Barbara Boehmer
  Repeat data based on count column
Oracle 11g Release 2, Linux
By: anil_mk on Thu, 11 August 2016
5 516 Fri, 12 August 2016 07:23
By: anil_mk
  Need to Retrieve data from JSON file in Oracle sql select query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 11 August 2016
9 775 Wed, 17 August 2016 04:20
By: Michel Cadot
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 480 Thu, 11 August 2016 05:31
By: cvs_1984
  Dynamic SQL Learning
11g
By: Irish88 on Wed, 10 August 2016
7 708 Thu, 18 August 2016 12:10
By: Irish88
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 690 Tue, 16 August 2016 08:08
By: Michel Cadot
  Query help
Oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 08 August 2016
6 619 Tue, 09 August 2016 16:21
By: sspn2010
  UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist
Oracle DB, 10g R2, Windows Server 2008R2
By: mdsirajoddin on Sat, 06 August 2016
12 2070 Sat, 06 August 2016 10:38
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 26 07:54:43 CDT 2017

Total time taken to generate the page: 0.01851 seconds