Pl sql case语句应用实例

Select  UserName,FileUpTime,RecordState,
case RecordState 
   when 0 then  '待审核'
   when 1 then '通过'
 end as stateName
  


 from tbSLUpLoadRecord
 where RECORDSTATE=0 or RecordState=1