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: 64470
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: Sun Feb 26 22:33:16 CST 2017

Total time taken to generate the page: 0.05528 seconds