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
  how to remove columns not ending with leaf nodes in hierarchical queries
11g,toad 12.1
By: ashwanth77 on Sat, 12 April 2014
9 833 Tue, 15 April 2014 03:37
By: ashwanth77
  select query
10g
By: foopaloop on Mon, 14 April 2014
1 347 Mon, 14 April 2014 22:40
By: BlackSwan
  (non)Matching nulls
By: tmcallister on Mon, 14 April 2014
2 275 Mon, 14 April 2014 10:48
By: tmcallister
  how can i insert 00-jan-2014 into a date column
By: ramadurga on Mon, 14 April 2014
20 968 Mon, 14 April 2014 10:28
By: Michel Cadot
  Delete all levels of employees those who are under BLAKE?
By: kiranrathodkr916 on Mon, 14 April 2014
4 416 Mon, 14 April 2014 09:15
By: Solomon Yakobson
  Remove the department in dept table where dept does not have any employees?
By: kiranrathodkr916 on Mon, 14 April 2014
4 327 Mon, 14 April 2014 06:26
By: cookiemonster
  Remove all entries except last one
Oracle Database 11.2.0.3 Enterprise Edition
By: manubatham20 on Sun, 13 April 2014
16 1005 Mon, 14 April 2014 06:26
By: Michel Cadot
  can any one help me in forming the below requested query
By: karthik7narla on Mon, 14 April 2014
3 470 Mon, 14 April 2014 03:23
By: Michel Cadot
  Distinct & Group By when used Analytic Function
By: mist598 on Mon, 14 April 2014
2 392 Mon, 14 April 2014 02:20
By: mist598
  Historical Data Delete Query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: ArjunK on Sun, 13 April 2014
2 358 Mon, 14 April 2014 00:12
By: Littlefoot
  how to overcome mutating table error
11g,toad 12.1
By: ashwanth77 on Fri, 11 April 2014
5 654 Sun, 13 April 2014 23:22
By: flyboy
  arrange
By: ghosh898 on Sun, 13 April 2014
2 251 Sun, 13 April 2014 18:38
By: Solomon Yakobson
  PL SQL prime number program explanation.
PL SQL
By: pkchethan on Sun, 13 April 2014
3 562 Sun, 13 April 2014 09:18
By: BlackSwan
  ORA-01830: date format picture ends before converting entire input string
Oracle 11g
By: na.dharma@gmail.com on Sat, 12 April 2014
2 551 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 522 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 768 Sat, 12 April 2014 05:11
By: OraFaq13
  # character is used in column
Oracle 10g
By: sss111ind on Sat, 12 April 2014
3 425 Sat, 12 April 2014 03:09
By: Littlefoot
  write a oracle query
oracle 10gR2 RHEL
By: 9390512774 on Fri, 11 April 2014
16 665 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 309 Fri, 11 April 2014 10:43
By: Michel Cadot
  ORACLE QUERY
By: juluruvenu on Fri, 11 April 2014
2 384 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 660 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 1920 Fri, 11 April 2014 01:35
By: Bikash.p
  Taking a Snapshot
Oracle 11g
By: themitch on Thu, 10 April 2014
9 438 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 471 Fri, 11 April 2014 01:08
By: vslabs
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 995 Thu, 10 April 2014 12:55
By: kiranrathodkr916
  date column issue
oracle 11.3
By: guddu_12 on Thu, 10 April 2014
12 363 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 475 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 387 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 248 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 773 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 822 Thu, 10 April 2014 01:02
By: Michel Cadot
  How to work oracle index
By: aaditya321 on Tue, 08 April 2014
6 545 Thu, 10 April 2014 00:39
By: pablolee
  Oracle - generating combination of numbers
By: electriceel on Mon, 25 October 2010
26 4140 Wed, 09 April 2014 13:06
By: Kosmadog
  ora 01722 invalid number error
By: ashwanth77 on Tue, 08 April 2014
8 645 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 259 Wed, 09 April 2014 06:09
By: John Watson
  Min emp details
Oracle 10g
By: sss111ind on Wed, 09 April 2014
1 276 Wed, 09 April 2014 05:30
By: Michel Cadot
  optimize query
11 i
By: usmanelahi on Wed, 09 April 2014
1 283 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 650 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 584 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 481 Tue, 08 April 2014 06:12
By: Littlefoot
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 21 14:53:34 CST 2014

Total time taken to generate the page: 0.05760 seconds