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
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 682 Thu, 10 April 2014 12:55
By: kiranrathodkr916
  date column issue
oracle 11.3
By: guddu_12 on Thu, 10 April 2014
12 199 Thu, 10 April 2014 12:35
By: joy_division
  Generating PDF files at oracle 10g server
oracle 10g Linux
By: manyal on Tue, 08 April 2014
6 225 Thu, 10 April 2014 12:33
By: Michel Cadot
  How to fetch last N records from the table?
By: Bikash.p on Thu, 10 April 2014
14 227 Thu, 10 April 2014 08:01
By: Michel Cadot
  "Where 1=2 " . How it works internally?
By: Bikash.p on Thu, 10 April 2014
3 122 Thu, 10 April 2014 05:46
By: Bikash.p
  How to return 0 when Inline View is returning NULL
Oracle - 11.1.0.7.0
By: akash.nathile on Thu, 06 September 2012
8 595 Thu, 10 April 2014 02:36
By: cookiemonster
  CONCATENATE QUERY
ORACLE, 8.1.7.0.0, WINDOWS 2007
By: kumarvk on Tue, 08 April 2014
11 532 Thu, 10 April 2014 01:02
By: Michel Cadot
  How to work oracle index
By: aaditya321 on Tue, 08 April 2014
6 401 Thu, 10 April 2014 00:39
By: pablolee
  Oracle - generating combination of numbers
By: electriceel on Mon, 25 October 2010
26 3158 Wed, 09 April 2014 13:06
By: Kosmadog
  ora 01722 invalid number error
By: ashwanth77 on Tue, 08 April 2014
8 408 Wed, 09 April 2014 06:48
By: Lalit Kumar B
  Sort Join understanding
Oracle 11g, Linux
By: rekha.singhal@tcs.com on Wed, 09 April 2014
1 150 Wed, 09 April 2014 06:09
By: John Watson
  Min emp details
Oracle 10g
By: sss111ind on Wed, 09 April 2014
1 184 Wed, 09 April 2014 05:30
By: Michel Cadot
  optimize query
11 i
By: usmanelahi on Wed, 09 April 2014
1 158 Wed, 09 April 2014 01:19
By: Michel Cadot
  Avoiding duplicate SQL code
Oracle
By: na.dharma@gmail.com on Fri, 04 April 2014
6 435 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 255 Tue, 08 April 2014 09:04
By: sss111ind
  How to get last two max values
Oracle 11g
By: na.dharma@gmail.com on Tue, 08 April 2014
5 274 Tue, 08 April 2014 06:12
By: Littlefoot
  Oracle 10g : Connect by prior
By: ashwanth77 on Tue, 08 April 2014
3 211 Tue, 08 April 2014 04:38
By: Michel Cadot
  Job not being executed on time
Oracle 11g r2 , Linux OEM 5.9
By: Andrey_R on Mon, 07 April 2014
10 434 Tue, 08 April 2014 03:12
By: Andrey_R
  Manipulating XML Clob
Oracle 11.2
By: deepugun on Mon, 07 April 2014
1 162 Mon, 07 April 2014 19:37
By: BlackSwan
  How to write query for desire output?
By: aaditya321 on Sat, 29 March 2014
4 377 Mon, 07 April 2014 03:58
By: Michel Cadot
  mutually exclusive query
Oracle, SQL
By: ravikanth_b on Sun, 06 April 2014
3 231 Mon, 07 April 2014 01:41
By: ravikanth_b
  Remove least paid employee who are reporting to BLAKE ?
By: kiranrathodkr916 on Sun, 06 April 2014
6 285 Sun, 06 April 2014 13:27
By: EdStevens
  Two row into one row conversition
Oralce 11g
By: na.dharma@gmail.com on Fri, 04 April 2014
9 420 Fri, 04 April 2014 10:04
By: Michel Cadot
  incorrect output from my sql command
11g
By: kekanap on Thu, 03 April 2014
6 393 Fri, 04 April 2014 10:01
By: Michel Cadot
  finding missing parent from oracle hierarchical query
11g
By: ashwanth77 on Fri, 04 April 2014
8 407 Fri, 04 April 2014 08:25
By: flyboy
  ORA-12899: value too large for column
Oracle 11g
By: na.dharma@gmail.com on Fri, 04 April 2014
3 252 Fri, 04 April 2014 02:00
By: Michel Cadot
  Date Format
By: gauravgautam135 on Thu, 03 April 2014
16 714 Fri, 04 April 2014 00:26
By: gauravgautam135
  sysdate problem with between()
8i
By: bobghw on Thu, 03 April 2014
4 179 Thu, 03 April 2014 19:19
By: bobghw
  Process cursor grp
Oracle 11g
By: namitanamburi on Thu, 03 April 2014
0 360 Thu, 03 April 2014 14:33
By: namitanamburi
  SQL Sub Query Error ORA-00936: missing expression
Oracle 11
By: rlcaputo on Thu, 03 April 2014
4 299 Thu, 03 April 2014 13:28
By: rlcaputo
  Adding subpartitions in template
By: Alexey.Samoilov on Thu, 03 April 2014
0 332 Thu, 03 April 2014 13:08
By: Alexey.Samoilov
  Select distinct record based on NULL date or most recent date
2005 SQL SSIS
By: jbaisch on Wed, 02 April 2014
19 775 Thu, 03 April 2014 09:39
By: cookiemonster
  Dates
By: mist598 on Wed, 02 April 2014
21 707 Thu, 03 April 2014 06:45
By: EdStevens
  Need to get only characters from the given string
By: saipradyumn on Thu, 03 April 2014
2 155 Thu, 03 April 2014 06:15
By: saipradyumn
  before insert & instead OF INSERT trigger
By: mist598 on Thu, 03 April 2014
11 337 Thu, 03 April 2014 04:32
By: cookiemonster
  Sharing column for partitions.
By: Alexey.Samoilov on Thu, 03 April 2014
6 303 Thu, 03 April 2014 03:43
By: Alexey.Samoilov
  Unable to get running total conditionally
Oracle Database 10g Rel.2
By: mazam on Wed, 02 April 2014
6 339 Thu, 03 April 2014 01:43
By: mazam
  Problems in Oracle Hints
By: aaditya321 on Wed, 02 April 2014
4 222 Thu, 03 April 2014 00:55
By: aaditya321
  passing values from Refcursor into Object type
Oracle 9i
By: anoopmanagoli on Wed, 02 April 2014
1 104 Wed, 02 April 2014 23:29
By: BlackSwan
  Group Values by date/Pivot in PLSQL query
plsql
By: manishc1989 on Wed, 02 April 2014
1 156 Wed, 02 April 2014 10:51
By: Michel Cadot
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: Thu Apr 17 22:52:59 CDT 2014

Total time taken to generate the page: 0.16972 seconds