同意楼上的如:
select decode('abc','a',1,
                    'b',2,
                    'c',3
                     -1) "Decoe 1" 
from dual;