Help req [message #157910] |
Tue, 07 February 2006 03:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vinu.m@naizak.com
Messages: 6 Registered: June 2005
|
Junior Member |
|
|
I have a status column haveing values "A", "C", etc. I need to display "Approved" instead of "A", "Closed" instead of "C" in the report. How can i do that? Thanks in advance
|
|
|
Re: Help req [message #157935 is a reply to message #157910] |
Tue, 07 February 2006 05:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Using the DECODE function:
SELECT DECODE(status, 'A', 'Approved', 'C', 'Closed', 'Unknown')
FROM ...
WHERE ...
|
|
|