Oracle case when else

 select  id  ,sname ,
 (case  when sex =1 then   '男'
 when  sex =0 then  '女'
 else  '人妖'
 end)  mysex 
 from  tab_student 

select id ,sname , sex ,
(case  sex 
  when  1  then  '男'
  when  0  then  '女'
  ELSE  '人妖'
  END )  性别
 from  tab_student 

或者

 select  id  ,sname ,
 (case  when sex =1 then   '男'
 when  sex =0 then  '女'
 else  '人妖'
 end)  mysex 
 from  tab_student