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
  Export of Table Data to Excel through PL/SQL code
Oracle Database 10g Enterprise Edition,10.2.0.4.0,IBM AIX64/RS6000 V4 - 8.1.0
By: bikash on Fri, 20 January 2012
5 1934 Fri, 11 April 2014 01:35
By: Bikash.p
  Taking a Snapshot
Oracle 11g
By: themitch on Thu, 10 April 2014
9 444 Fri, 11 April 2014 01:28
By: John Watson
  How can we access an object type(not table of objects) in Oracle TABLE function?
Oracle 10R2
By: balaji.chelladurai on Thu, 10 April 2014
5 479 Fri, 11 April 2014 01:08
By: vslabs
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 1006 Thu, 10 April 2014 12:55
By: kiranrathodkr916
  date column issue
oracle 11.3
By: guddu_12 on Thu, 10 April 2014
12 371 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 483 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 394 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 255 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 776 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 833 Thu, 10 April 2014 01:02
By: Michel Cadot
  How to work oracle index
By: aaditya321 on Tue, 08 April 2014
6 550 Thu, 10 April 2014 00:39
By: pablolee
  Oracle - generating combination of numbers
By: electriceel on Mon, 25 October 2010
26 4161 Wed, 09 April 2014 13:06
By: Kosmadog
  ora 01722 invalid number error
By: ashwanth77 on Tue, 08 April 2014
8 654 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 268 Wed, 09 April 2014 06:09
By: John Watson
  Min emp details
Oracle 10g
By: sss111ind on Wed, 09 April 2014
1 281 Wed, 09 April 2014 05:30
By: Michel Cadot
  optimize query
11 i
By: usmanelahi on Wed, 09 April 2014
1 287 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 658 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 591 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 491 Tue, 08 April 2014 06:12
By: Littlefoot
  Oracle 10g : Connect by prior
By: ashwanth77 on Tue, 08 April 2014
3 337 Tue, 08 April 2014 04:38
By: Michel Cadot
  Manipulating XML Clob
Oracle 11.2
By: deepugun on Mon, 07 April 2014
1 302 Mon, 07 April 2014 19:37
By: BlackSwan
  How to write query for desire output?
By: aaditya321 on Sat, 29 March 2014
4 536 Mon, 07 April 2014 03:58
By: Michel Cadot
  mutually exclusive query
Oracle, SQL
By: ravikanth_b on Sun, 06 April 2014
3 415 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 507 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 610 Fri, 04 April 2014 10:04
By: Michel Cadot
  incorrect output from my sql command
11g
By: kekanap on Thu, 03 April 2014
6 625 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 661 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 392 Fri, 04 April 2014 02:00
By: Michel Cadot
  Date Format
By: gauravgautam135 on Thu, 03 April 2014
16 1032 Fri, 04 April 2014 00:26
By: gauravgautam135
  sysdate problem with between()
8i
By: bobghw on Thu, 03 April 2014
4 281 Thu, 03 April 2014 19:19
By: bobghw
  Process cursor grp
Oracle 11g
By: namitanamburi on Thu, 03 April 2014
0 457 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 440 Thu, 03 April 2014 13:28
By: rlcaputo
  Adding subpartitions in template
By: Alexey.Samoilov on Thu, 03 April 2014
0 418 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 1033 Thu, 03 April 2014 09:39
By: cookiemonster
  Dates
By: mist598 on Wed, 02 April 2014
21 926 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 269 Thu, 03 April 2014 06:15
By: saipradyumn
  before insert & instead OF INSERT trigger
By: mist598 on Thu, 03 April 2014
11 661 Thu, 03 April 2014 04:32
By: cookiemonster
  Sharing column for partitions.
By: Alexey.Samoilov on Thu, 03 April 2014
6 422 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 563 Thu, 03 April 2014 01:43
By: mazam
  Problems in Oracle Hints
By: aaditya321 on Wed, 02 April 2014
4 330 Thu, 03 April 2014 00:55
By: aaditya321
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 Dec 28 12:00:59 CST 2014

Total time taken to generate the page: 0.10861 seconds