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 36976 Mon, 05 September 2011 02:20
By: Littlefoot
  Find out last four digits
Oracle
By: Shyam.reddy141 on Thu, 24 April 2014
3 41 Thu, 24 April 2014 13:13
By: Solomon Yakobson
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
24 6949 Thu, 24 April 2014 11:10
By: EdStevens
  Case Statement - Best Practice - Close with Else Null?
SQL
By: smedvid on Thu, 24 April 2014
2 115 Thu, 24 April 2014 10:12
By: smedvid
  ORA-28002 error while connecting DB LINK
By: Bikash.p on Wed, 23 April 2014
9 281 Thu, 24 April 2014 09:47
By: EdStevens
  New to sql and need some help please (merged)
SQL Plus
By: om357 on Wed, 23 April 2014
15 633 Thu, 24 April 2014 00:58
By: Michel Cadot
Need to Understand Explain plan has been moved to Performance Tuning by the moderator.
  Unable to display contents of CHARARR;
SQL Developer
By: plsqlnewbie on Tue, 22 April 2014
12 302 Wed, 23 April 2014 09:06
By: Solomon Yakobson
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
24 868 Wed, 23 April 2014 07:44
By: Michel Cadot
  Job not being executed on time
Oracle 11g r2 , Linux OEM 5.9
By: Andrey_R on Mon, 07 April 2014
12 573 Wed, 23 April 2014 05:56
By: Michel Cadot
How to save time format to 24 hour while importing data from xls file has been moved to Client Tools by the moderator.
  join field depending on condition
DB Visualizer SQL ORACLE
By: epr55 on Tue, 22 April 2014
8 241 Tue, 22 April 2014 13:12
By: Michel Cadot
  Data Type Number
Oracle 11g
By: teck_lee80@yahoo.com on Mon, 21 April 2014
5 226 Tue, 22 April 2014 01:36
By: Michel Cadot
performance Tuning has been moved to Performance Tuning by the moderator.
  How to join two table with no duplicate
By: ocpsujon on Sun, 20 April 2014
17 838 Sun, 20 April 2014 22:34
By: ocpsujon
  case insensitive search UPPER/LOWER() vs. NLSSORT
Oracle 10g
By: rc3d on Sun, 20 April 2014
2 255 Sun, 20 April 2014 09:19
By: Lalit Kumar B
  Searching a string and replacing with value
Oracle 10g
By: sss111ind on Fri, 11 April 2014
13 922 Sat, 19 April 2014 01:55
By: sss111ind
  Transpose query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Wed, 16 April 2014
13 987 Fri, 18 April 2014 11:59
By: sspn2010
  for loop
11g
By: ggggg on Sun, 02 March 2014
12 647 Fri, 18 April 2014 07:32
By: Solomon Yakobson
  sp_log_entry
By: thelearner on Thu, 17 April 2014
2 138 Thu, 17 April 2014 17:06
By: BlackSwan
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
12 519 Thu, 17 April 2014 16:21
By: dariyoosh
  Need to get max update date time last 7 days
11
By: cplusplus1 on Thu, 17 April 2014
3 270 Thu, 17 April 2014 12:52
By: Littlefoot
  Missing right paren... subquery trouble
Oracle 11g
By: pagoo on Wed, 16 April 2014
3 447 Wed, 16 April 2014 09:36
By: Michel Cadot
  query of status changed
11g
By: usmanelahi on Tue, 15 April 2014
8 481 Wed, 16 April 2014 06:17
By: Solomon Yakobson
  Date in Words
By: vipul.gupta2 on Wed, 16 April 2014
5 471 Wed, 16 April 2014 02:09
By: vipul.gupta2
  Help with PL Packages
Oracle SQL
By: cman348powah on Tue, 15 April 2014
2 285 Wed, 16 April 2014 01:13
By: vslabs
  Create table in sqlplus script
oracle 11g, windows os
By: anncao on Tue, 15 April 2014
4 245 Tue, 15 April 2014 20:20
By: EdStevens
  how to use joins in hierarchical queries
11g
By: ashwanth77 on Tue, 15 April 2014
2 126 Tue, 15 April 2014 11:31
By: Michel Cadot
  ORA-29283: invalid file operation
Oracle 10g Enterprise, HPUX-B.11.11
By: bryant1003 on Tue, 15 April 2014
18 695 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 665 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 626 Tue, 15 April 2014 03:37
By: ashwanth77
  select query
10g
By: foopaloop on Mon, 14 April 2014
1 211 Mon, 14 April 2014 22:40
By: BlackSwan
  (non)Matching nulls
By: tmcallister on Mon, 14 April 2014
2 128 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 688 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 281 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 204 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 773 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 308 Mon, 14 April 2014 03:23
By: Michel Cadot
  Distinct & Group By when used Analytic Function
By: mist598 on Mon, 14 April 2014
2 246 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 238 Mon, 14 April 2014 00: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: Thu Apr 24 13:49:51 CDT 2014

Total time taken to generate the page: 0.16219 seconds