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
  ORA-01830: date format picture ends before converting entire input string
Oracle 11g
By: na.dharma@gmail.com on Sat, 12 April 2014
2 445 Sat, 12 April 2014 13:53
By: Michel Cadot
  Multiple counts as one
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: OraFaq13 on Wed, 09 April 2014
4 474 Sat, 12 April 2014 12:27
By: OraFaq13
  Outer Join and MAX
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: OraFaq13 on Fri, 11 April 2014
10 702 Sat, 12 April 2014 05:11
By: OraFaq13
  # character is used in column
Oracle 10g
By: sss111ind on Sat, 12 April 2014
3 381 Sat, 12 April 2014 03:09
By: Littlefoot
  write a oracle query
oracle 10gR2 RHEL
By: 9390512774 on Fri, 11 April 2014
16 604 Fri, 11 April 2014 14:43
By: Solomon Yakobson
icon5.gif Error in Stored procedure
11G with ODAC
By: newbieDeveloper on Fri, 11 April 2014
4 271 Fri, 11 April 2014 10:43
By: Michel Cadot
  ORACLE QUERY
By: juluruvenu on Fri, 11 April 2014
2 350 Fri, 11 April 2014 02:27
By: Michel Cadot
  Suggestion for Oracle AQ Dequeue Approach
Oracle 10R2
By: balaji.chelladurai on Thu, 10 April 2014
4 559 Fri, 11 April 2014 02:04
By: balaji.chelladurai
  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 1844 Fri, 11 April 2014 01:35
By: Bikash.p
  Taking a Snapshot
Oracle 11g
By: themitch on Thu, 10 April 2014
9 380 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 411 Fri, 11 April 2014 01:08
By: vslabs
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 905 Thu, 10 April 2014 12:55
By: kiranrathodkr916
  date column issue
oracle 11.3
By: guddu_12 on Thu, 10 April 2014
12 328 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 412 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 335 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 219 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 715 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 731 Thu, 10 April 2014 01:02
By: Michel Cadot
  How to work oracle index
By: aaditya321 on Tue, 08 April 2014
6 506 Thu, 10 April 2014 00:39
By: pablolee
  Oracle - generating combination of numbers
By: electriceel on Mon, 25 October 2010
26 3833 Wed, 09 April 2014 13:06
By: Kosmadog
  ora 01722 invalid number error
By: ashwanth77 on Tue, 08 April 2014
8 572 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 233 Wed, 09 April 2014 06:09
By: John Watson
  Min emp details
Oracle 10g
By: sss111ind on Wed, 09 April 2014
1 257 Wed, 09 April 2014 05:30
By: Michel Cadot
  optimize query
11 i
By: usmanelahi on Wed, 09 April 2014
1 267 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 606 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 430 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 433 Tue, 08 April 2014 06:12
By: Littlefoot
  Oracle 10g : Connect by prior
By: ashwanth77 on Tue, 08 April 2014
3 313 Tue, 08 April 2014 04:38
By: Michel Cadot
  Manipulating XML Clob
Oracle 11.2
By: deepugun on Mon, 07 April 2014
1 255 Mon, 07 April 2014 19:37
By: BlackSwan
  How to write query for desire output?
By: aaditya321 on Sat, 29 March 2014
4 494 Mon, 07 April 2014 03:58
By: Michel Cadot
  mutually exclusive query
Oracle, SQL
By: ravikanth_b on Sun, 06 April 2014
3 367 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 446 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 543 Fri, 04 April 2014 10:04
By: Michel Cadot
  incorrect output from my sql command
11g
By: kekanap on Thu, 03 April 2014
6 551 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 577 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 370 Fri, 04 April 2014 02:00
By: Michel Cadot
  Date Format
By: gauravgautam135 on Thu, 03 April 2014
16 915 Fri, 04 April 2014 00:26
By: gauravgautam135
  sysdate problem with between()
8i
By: bobghw on Thu, 03 April 2014
4 252 Thu, 03 April 2014 19:19
By: bobghw
  Process cursor grp
Oracle 11g
By: namitanamburi on Thu, 03 April 2014
0 442 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 406 Thu, 03 April 2014 13:28
By: rlcaputo
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: Tue Sep 23 18:05:33 CDT 2014

Total time taken to generate the page: 0.09079 seconds