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
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 3636 Mon, 05 September 2011 02:20
By: Littlefoot
  Nested Query- Result Achieved. Performance improvement ?
10.2.0.1.0
By: bluetooth420 on Thu, 22 September 2016
17 459 Sat, 24 September 2016 15:01
By: Solomon Yakobson
  Date Time problem in sql server
Oracle 10g
By: sss111ind on Fri, 23 September 2016
11 384 Sat, 24 September 2016 00:59
By: Michel Cadot
icon11.gif Count Adult Age in Range Time in 2016
Windows
By: blogbeka on Wed, 21 September 2016
11 339 Thu, 22 September 2016 04:22
By: cookiemonster
  Fixed Width Flat file via Oracle table
11g,win 7
By: shumail on Thu, 15 September 2016
6 352 Wed, 21 September 2016 13:27
By: shumail
  Missing Record in running Total
10.2.0
By: bluetooth420 on Sat, 17 September 2016
23 703 Wed, 21 September 2016 02:13
By: bluetooth420
  PL/SQL Function fails without an exception
Oracle 12c
By: moverdear on Mon, 19 September 2016
3 170 Mon, 19 September 2016 17:27
By: Barbara Boehmer
  Materialised views not refreshing
Oracle 11g Release 11.2.0.4.0
By: brown_zzz on Thu, 15 September 2016
2 333 Mon, 19 September 2016 11:47
By: Michel Cadot
  DECLARE a FUNCTION
By: derrellgore on Thu, 15 September 2016
6 323 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 331 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 265 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 252 Fri, 16 September 2016 10:12
By: BlackSwan
icon5.gif Enforce blank record
Oracle 11G
By: OlafCologne on Thu, 15 September 2016
3 203 Thu, 15 September 2016 12:49
By: Michel Cadot
  Global Temporary Tables
By: derrellgore on Tue, 13 September 2016
12 512 Thu, 15 September 2016 03:19
By: cookiemonster
  Data grouping
Oracle 11g
By: srinivas.k2005 on Wed, 14 September 2016
7 412 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 319 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 260 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 401 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 426 Mon, 12 September 2016 06:59
By: Flyby
  Problems converting String to data
By: RubenDC on Mon, 12 September 2016
5 225 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 665 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 714 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 1009 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 161 Tue, 06 September 2016 14:31
By: Michel Cadot
  Selecting the columns
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 06 September 2016
6 273 Tue, 06 September 2016 08:16
By: BlackSwan
  select statement to split string as per the content and show it
oracle 11g, windows
By: chinmay89 on Wed, 31 August 2016
5 356 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 285 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 309 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 261 Thu, 01 September 2016 06:33
By: Michel Cadot
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 269 Wed, 31 August 2016 15:16
By: DivP
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 506 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 218 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 322 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 575 Mon, 29 August 2016 23:00
By: grpatwari
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 428 Fri, 26 August 2016 23:25
By: vickytalware
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 530 Fri, 26 August 2016 02:46
By: saipradyumn
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 298 Fri, 26 August 2016 02:43
By: glmjoy
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 355 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 343 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 502 Thu, 25 August 2016 06:37
By: EdStevens
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 Sep 25 04:17:44 CDT 2016

Total time taken to generate the page: 0.08885 seconds