Home » SQL & PL/SQL » SQL & PL/SQL » i want to display the alphabetic letters for the range of salaries by using decode (oracle 10g)
i want to display the alphabetic letters for the range of salaries by using decode [message #379551] Wed, 07 January 2009 00:42 Go to next message
manickavasan
Messages: 7
Registered: July 2008
Location: india
Junior Member

i want to display the alphabetic letters for the range of salaries by using decode.But i could achieve it using CASE WHEN BETWEEN.
select (case when salary between 1001 and 3000 then 'a'
when salary between 3001 and 6000 then 'b'
when salary between 4001 and 9000 then 'c' else 'd' end) from table1;

Re: i want to display the alphabetic letters for the range of salaries by using decode [message #379555 is a reply to message #379551] Wed, 07 January 2009 00:46 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SIGN.

Regards
Michel
Previous Topic: Job alert
Next Topic: Materialized view
Goto Forum:
  


Current Time: Thu Dec 08 10:44:59 CST 2016

Total time taken to generate the page: 0.14781 seconds