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
icon11.gif Count Adult Age in Range Time in 2016
Windows
By: blogbeka on Wed, 21 September 2016
11 902 Thu, 22 September 2016 04:22
By: cookiemonster
  Missing Record in running Total
10.2.0
By: bluetooth420 on Sat, 17 September 2016
23 1662 Wed, 21 September 2016 02:13
By: bluetooth420
  Materialised views not refreshing
Oracle 11g Release 11.2.0.4.0
By: brown_zzz on Thu, 15 September 2016
2 699 Mon, 19 September 2016 11:47
By: Michel Cadot
  DECLARE a FUNCTION
By: derrellgore on Thu, 15 September 2016
6 813 Mon, 19 September 2016 08:59
By: Bill B
  SQL%ROWCOUNT
SQL*Plus: Release 12.1.0.1.0, Linux x86 64-bit
By: anders_e on Fri, 16 September 2016
4 816 Mon, 19 September 2016 07:27
By: anders_e
  Dynamic SQL : ORA-01006: bind variable does not exist (merged)
Oracle R12
By: ajayhareesh on Sun, 18 September 2016
12 1506 Sun, 18 September 2016 14:01
By: ajayhareesh
  ORA-01847: day of month must be between 1 and last day of month 01847. 00000 - "day of month must b
Oracle
By: ROHIN on Fri, 16 September 2016
4 798 Fri, 16 September 2016 10:12
By: BlackSwan
icon5.gif Enforce blank record
Oracle 11G
By: OlafCologne on Thu, 15 September 2016
3 511 Thu, 15 September 2016 12:49
By: Michel Cadot
  Global Temporary Tables
By: derrellgore on Tue, 13 September 2016
12 1309 Thu, 15 September 2016 03:19
By: cookiemonster
  Data grouping
Oracle 11g
By: srinivas.k2005 on Wed, 14 September 2016
7 823 Thu, 15 September 2016 02:17
By: srinivas.k2005
  Invalid Chars notify differently in different file editors
11G
By: harshadsp on Tue, 13 September 2016
6 749 Tue, 13 September 2016 02:46
By: Michel Cadot
  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 577 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 761 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 954 Mon, 12 September 2016 06:59
By: Flyby
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 721 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 1798 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 1731 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 1741 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 458 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 726 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 686 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 779 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 765 Thu, 01 September 2016 06:33
By: Michel Cadot
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 611 Wed, 31 August 2016 15:16
By: DivP
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 1236 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 543 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 667 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 973 Mon, 29 August 2016 23:00
By: grpatwari
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 10704 Fri, 26 August 2016 23:25
By: vickytalware
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 872 Fri, 26 August 2016 02:46
By: saipradyumn
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 732 Fri, 26 August 2016 02:43
By: glmjoy
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 692 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 580 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 1050 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 665 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 915 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 622 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 1211 Mon, 22 August 2016 04:51
By: sandeep_orafaq
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 1004 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 1012 Fri, 19 August 2016 14:28
By: BlackSwan
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 Apr 23 16:32:01 CDT 2018

Total time taken to generate the page: 0.03024 seconds