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 can i insert 00-jan-2014 into a date column
By: ramadurga on Mon, 14 April 2014
20 840 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 368 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 274 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 889 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 393 Mon, 14 April 2014 03:23
By: Michel Cadot
  Distinct & Group By when used Analytic Function
By: mist598 on Mon, 14 April 2014
2 328 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 304 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 544 Sun, 13 April 2014 23:22
By: flyboy
  arrange
By: ghosh898 on Sun, 13 April 2014
2 205 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 444 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 407 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 451 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 676 Sat, 12 April 2014 05:11
By: OraFaq13
  # character is used in column
Oracle 10g
By: sss111ind on Sat, 12 April 2014
3 361 Sat, 12 April 2014 03:09
By: Littlefoot
  write a oracle query
oracle 10gR2 RHEL
By: 9390512774 on Fri, 11 April 2014
16 579 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 253 Fri, 11 April 2014 10:43
By: Michel Cadot
  ORACLE QUERY
By: juluruvenu on Fri, 11 April 2014
2 339 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 530 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 1817 Fri, 11 April 2014 01:35
By: Bikash.p
  Taking a Snapshot
Oracle 11g
By: themitch on Thu, 10 April 2014
9 352 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 381 Fri, 11 April 2014 01:08
By: vslabs
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 866 Thu, 10 April 2014 12:55
By: kiranrathodkr916
  date column issue
oracle 11.3
By: guddu_12 on Thu, 10 April 2014
12 292 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 375 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 305 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 189 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 687 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 695 Thu, 10 April 2014 01:02
By: Michel Cadot
  How to work oracle index
By: aaditya321 on Tue, 08 April 2014
6 488 Thu, 10 April 2014 00:39
By: pablolee
  Oracle - generating combination of numbers
By: electriceel on Mon, 25 October 2010
26 3671 Wed, 09 April 2014 13:06
By: Kosmadog
  ora 01722 invalid number error
By: ashwanth77 on Tue, 08 April 2014
8 534 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 212 Wed, 09 April 2014 06:09
By: John Watson
  Min emp details
Oracle 10g
By: sss111ind on Wed, 09 April 2014
1 244 Wed, 09 April 2014 05:30
By: Michel Cadot
  optimize query
11 i
By: usmanelahi on Wed, 09 April 2014
1 258 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 568 Tue, 08 April 2014 09:43
By: pablolee
  Date format error
Oracle 10g
By: sss111ind on Tue, 08 April 2014
5 388 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 407 Tue, 08 April 2014 06:12
By: Littlefoot
  Oracle 10g : Connect by prior
By: ashwanth77 on Tue, 08 April 2014
3 294 Tue, 08 April 2014 04:38
By: Michel Cadot
  Manipulating XML Clob
Oracle 11.2
By: deepugun on Mon, 07 April 2014
1 244 Mon, 07 April 2014 19:37
By: BlackSwan
  How to write query for desire output?
By: aaditya321 on Sat, 29 March 2014
4 461 Mon, 07 April 2014 03:58
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: Fri Aug 22 06:53:27 CDT 2014

Total time taken to generate the page: 0.19158 seconds