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 422 Mon, 12 September 2016 19:45
By: BlackSwan
  Group by Multiple Values
Oracle 11.2.0.3 Windows
By: Duane on Mon, 12 September 2016
1 566 Mon, 12 September 2016 19:08
By: Solomon Yakobson
  Improve nested Query, if possible
10.2.0
By: bluetooth420 on Sun, 11 September 2016
6 635 Mon, 12 September 2016 06:59
By: Flyby
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 411 Mon, 12 September 2016 06:43
By: RubenDC
  Unique Constraint With DEFERRABLE INITIALLY DEFERRED NOVALIDATE
Oracle 11g 11.2.0.4.0
By: fixxxer on Fri, 09 September 2016
17 947 Sun, 11 September 2016 00:48
By: Michel Cadot
  Format result set of a union
DB 10g
By: adfnewbie on Mon, 29 August 2016
24 937 Wed, 07 September 2016 03:56
By: sandeep_orafaq
  Select columns based on first record (Header from flat file)
Oracle 11g, Windows 2012 R2
By: rahul1982 on Tue, 06 September 2016
20 1256 Wed, 07 September 2016 03:25
By: Michel Cadot
  Unpivot or Connect by
Oracle 11.2.0.3 Windows
By: Duane on Tue, 06 September 2016
2 300 Tue, 06 September 2016 14:31
By: Michel Cadot
  select statement to split string as per the content and show it
oracle 11g, windows
By: chinmay89 on Wed, 31 August 2016
5 514 Mon, 05 September 2016 04:20
By: sandeep_orafaq
  Hierarchy view
Oracle Database 12c Standard Edition Release 12.1.0.2.0
By: steveshephard87 on Sat, 03 September 2016
2 466 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 531 Fri, 02 September 2016 07:22
By: EdStevens
  Query to find special alphabets
Oracle 11g Release 2, Linux
By: anil_mk on Wed, 31 August 2016
5 478 Thu, 01 September 2016 06:33
By: Michel Cadot
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 408 Wed, 31 August 2016 15:16
By: DivP
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 722 Wed, 31 August 2016 08:22
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 373 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 464 Wed, 31 August 2016 05:34
By: anil_mk
  query to write rows to column values
11.2.0.4
By: grpatwari on Tue, 31 May 2016
13 734 Mon, 29 August 2016 23:00
By: grpatwari
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 597 Fri, 26 August 2016 23:25
By: vickytalware
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 690 Fri, 26 August 2016 02:46
By: saipradyumn
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 456 Fri, 26 August 2016 02:43
By: glmjoy
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 507 Thu, 25 August 2016 09:40
By: ALEXWE
  how to restrict set of data in oracle
oracle,12.1.0.2.0 ,windows7
By: saini006 on Thu, 25 August 2016
3 441 Thu, 25 August 2016 07:51
By: Michel Cadot
  Query to get Middle Record from a table
Oracle 11g
By: arifs3738 on Wed, 24 August 2016
8 701 Thu, 25 August 2016 06:37
By: EdStevens
icon5.gif Union of 4 different columns in Single Row
SQL, PLSQL
By: anil_apps on Wed, 24 August 2016
4 466 Thu, 25 August 2016 00:44
By: Michel Cadot
  Sequence partition clause
DB12.x (and possibly earlier)
By: John Watson on Tue, 23 August 2016
2 354 Tue, 23 August 2016 03:15
By: John Watson
  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 476 Mon, 22 August 2016 13:54
By: Barbara Boehmer
  How to remove duplicate value from type in SQL
Oracle 11i,Toad
By: victoryhendry on Tue, 16 August 2016
6 971 Mon, 22 August 2016 04:51
By: sandeep_orafaq
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 666 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 699 Fri, 19 August 2016 14:28
By: BlackSwan
  Dynamic SQL Learning
11g
By: Irish88 on Wed, 10 August 2016
7 628 Thu, 18 August 2016 12:10
By: Irish88
  ORA-01917 ERROR
By: mfahimaamirgmailcom on Thu, 18 August 2016
2 458 Thu, 18 August 2016 06:11
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 847 Wed, 17 August 2016 21:33
By: buggleboy007
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 468 Wed, 17 August 2016 14:04
By: Michel Cadot
  Renaming a table
Oracle 11
By: saipradyumn on Tue, 16 August 2016
6 541 Wed, 17 August 2016 07:28
By: Bill B
  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 719 Wed, 17 August 2016 06:45
By: wtolentino
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 605 Wed, 17 August 2016 06:28
By: Michel Cadot
  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 707 Wed, 17 August 2016 04:20
By: Michel Cadot
  keep only numeric values in a string
oracle 11g, windows
By: chinmay45 on Tue, 16 August 2016
18 586 Wed, 17 August 2016 01:35
By: Michel Cadot
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 573 Tue, 16 August 2016 08:08
By: Michel Cadot
  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 595 Sat, 13 August 2016 09:36
By: abdo2203
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 May 29 02:45:37 CDT 2017

Total time taken to generate the page: 0.05613 seconds