| decode problem [message #265853] |
Fri, 07 September 2007 11:36  |
ashish2345
Messages: 50
Registered: September 2007
|
Member |
|
|
I use oracle 9i. i had one question on decode.
my table member has columns age and name.
i want to decode my info as follows
age<18 minor
age =18 adult
age>18 and <60 mature
age>60 old
how can i do it in one statement...
thanks a lot in advance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: decode problem [message #266036 is a reply to message #266006] |
Sun, 09 September 2007 04:30  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
In simple cases, DECODE and CASE don't differ much; I prefer DECODE.
However, when there are nested DECODEs involved, it may be a real pain to write (and, especially, read an understand) it correctly, while CASE offers better comprehension of the same query.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
