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
  Improve nested Query, if possible
10.2.0
By: bluetooth420 on Sun, 11 September 2016
6 776 Mon, 12 September 2016 06:59
By: Flyby
  Global Temporary Tables
By: derrellgore on Tue, 13 September 2016
12 1034 Thu, 15 September 2016 03:19
By: cookiemonster
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 581 Mon, 12 September 2016 06:43
By: RubenDC
  Unpivot or Connect by
Oracle 11.2.0.3 Windows
By: Duane on Tue, 06 September 2016
2 359 Tue, 06 September 2016 14:31
By: Michel Cadot
  Select columns based on first record (Header from flat file)
Oracle 11g, Windows 2012 R2
By: rahul1982 on Tue, 06 September 2016
20 1470 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 564 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 657 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 1668 Fri, 04 November 2016 11:24
By: Solomon Yakobson
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 498 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 597 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 619 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 448 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 562 Wed, 31 August 2016 05:34
By: anil_mk
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 948 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 1348 Wed, 07 September 2016 03:56
By: sandeep_orafaq
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 608 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 494 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 562 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 863 Thu, 25 August 2016 06:37
By: EdStevens
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 767 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 632 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 8942 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 536 Mon, 22 August 2016 13:54
By: Barbara Boehmer
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 885 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 904 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 1289 Mon, 02 January 2017 23:20
By: grpatwari
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 577 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 945 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 813 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 745 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 1248 Sun, 25 September 2016 12:22
By: BlackSwan
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 716 Wed, 17 August 2016 06:28
By: Michel Cadot
  Renaming a table
Oracle 11
By: saipradyumn on Tue, 16 August 2016
6 632 Wed, 17 August 2016 07:28
By: Bill B
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 590 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 1090 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 718 Sat, 13 August 2016 09:36
By: abdo2203
  Help reverse engineering pl sql query
Oracle sql
By: jprisk on Fri, 12 August 2016
4 679 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 553 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 841 Wed, 17 August 2016 04:20
By: Michel Cadot
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 496 Thu, 11 August 2016 05:31
By: cvs_1984
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: Sat Nov 18 09:50:54 CST 2017

Total time taken to generate the page: 0.01547 seconds