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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 36828 Mon, 05 September 2011 02:20
By: Littlefoot
  Transpose query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Wed, 16 April 2014
1 141 Thu, 17 April 2014 00:40
By: Michel Cadot
  Missing right paren... subquery trouble
Oracle 11g
By: pagoo on Wed, 16 April 2014
3 399 Wed, 16 April 2014 09:36
By: Michel Cadot
  Searching a string and replacing with value
Oracle 10g
By: sss111ind on Fri, 11 April 2014
5 301 Wed, 16 April 2014 06:17
By: sss111ind
  query of status changed
11g
By: usmanelahi on Tue, 15 April 2014
8 432 Wed, 16 April 2014 06:17
By: Solomon Yakobson
  Date in Words
By: vipul.gupta2 on Wed, 16 April 2014
5 415 Wed, 16 April 2014 02:09
By: vipul.gupta2
  Help with PL Packages
Oracle SQL
By: cman348powah on Tue, 15 April 2014
2 236 Wed, 16 April 2014 01:13
By: vslabs
NUMBER datatype has been moved to Client Tools by the moderator.
  Create table in sqlplus script
oracle 11g, windows os
By: anncao on Tue, 15 April 2014
4 205 Tue, 15 April 2014 20:20
By: EdStevens
  how to use joins in hierarchical queries
11g
By: ashwanth77 on Tue, 15 April 2014
2 98 Tue, 15 April 2014 11:31
By: Michel Cadot
  Function to get column value
Oracle 10g
By: sss111ind on Tue, 15 April 2014
3 269 Tue, 15 April 2014 09:13
By: Lalit Kumar B
  ORA-29283: invalid file operation
Oracle 10g Enterprise, HPUX-B.11.11
By: bryant1003 on Tue, 15 April 2014
18 668 Tue, 15 April 2014 08:49
By: Solomon Yakobson
  How to check row count of sys_refcursor
Oracle11g
By: na.dharma@gmail.com on Tue, 15 April 2014
11 641 Tue, 15 April 2014 08:38
By: pointers
  how to remove columns not ending with leaf nodes in hierarchical queries
11g,toad 12.1
By: ashwanth77 on Sat, 12 April 2014
9 605 Tue, 15 April 2014 03:37
By: ashwanth77
  select query
10g
By: foopaloop on Mon, 14 April 2014
1 155 Mon, 14 April 2014 22:40
By: BlackSwan
  (non)Matching nulls
By: tmcallister on Mon, 14 April 2014
2 112 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 661 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 263 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 190 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 751 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 294 Mon, 14 April 2014 03:23
By: Michel Cadot
  Distinct & Group By when used Analytic Function
By: mist598 on Mon, 14 April 2014
2 233 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 222 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 368 Sun, 13 April 2014 23:22
By: flyboy
  arrange
By: ghosh898 on Sun, 13 April 2014
2 131 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 287 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 247 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 331 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 559 Sat, 12 April 2014 05:11
By: OraFaq13
  # character is used in column
Oracle 10g
By: sss111ind on Sat, 12 April 2014
3 269 Sat, 12 April 2014 03:09
By: Littlefoot
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
3 232 Sat, 12 April 2014 02:42
By: John Watson
  write a oracle query
oracle 10gR2 RHEL
By: 9390512774 on Fri, 11 April 2014
16 433 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 131 Fri, 11 April 2014 10:43
By: Michel Cadot
  ORACLE QUERY
By: juluruvenu on Fri, 11 April 2014
2 260 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 375 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 1600 Fri, 11 April 2014 01:35
By: Bikash.p
  Taking a Snapshot
Oracle 11g
By: themitch on Thu, 10 April 2014
9 247 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 290 Fri, 11 April 2014 01:08
By: vslabs
  oracle store procedure execution time takes too long
By: ashwanth77 on Wed, 09 April 2014
13 681 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
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 05:19:45 CDT 2014

Total time taken to generate the page: 0.23372 seconds