DECODE

----- DECODE function...

SELECT name,decode(upper(sex), 'M', 'Male',
'F', 'Female', 'Unknown') sex
FROM employee;