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: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SIGN.

Regards
Michel
Previous Topic: DISABLE CONSTRAINTS
Next Topic: Accessing other user's objects
Goto Forum:
  


Current Time: Wed Aug 23 01:05:56 CDT 2017

Total time taken to generate the page: 0.01873 seconds