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
  When we get the "Outbound Variable" Error in PLSQL
When we get the "Outbound Variable" Error in PLSQL
By: msyogi on Mon, 12 September 2016
2 482 Mon, 12 September 2016 19:45
By: BlackSwan
  Fixed Width Flat file via Oracle table
11g,win 7
By: shumail on Thu, 15 September 2016
7 773 Tue, 27 September 2016 15:42
By: Bill B
  Unique Constraint With DEFERRABLE INITIALLY DEFERRED NOVALIDATE
Oracle 11g 11.2.0.4.0
By: fixxxer on Fri, 09 September 2016
17 1418 Sun, 11 September 2016 00:48
By: Michel Cadot
  Improve nested Query, if possible
10.2.0
By: bluetooth420 on Sun, 11 September 2016
6 778 Mon, 12 September 2016 06:59
By: Flyby
  Global Temporary Tables
By: derrellgore on Tue, 13 September 2016
12 1036 Thu, 15 September 2016 03:19
By: cookiemonster
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 582 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 565 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 1669 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 620 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 449 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 949 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 1350 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 869 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 636 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 8955 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 537 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 1290 Mon, 02 January 2017 23:20
By: grpatwari
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 578 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 946 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 746 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
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 19 10:06:16 CST 2017

Total time taken to generate the page: 0.01429 seconds