个人博客创业记录-oracle metalink账号|Oracle Metalink账号注册指南

Pl sql case语句应用实例

Select  UserName,FileUpTime,RecordState,

case RecordState 

   when 0 then  '待审核'

   when 1 then '通过'

 oracle账号end as stateName

 from tbSLUpLoadRecord

 where RECORDSTATE=0 or RecordState=1