select logid,userid,logtime,url,description, (case operatetype when operatetype = 0 then ’新增’ when operatetype=1 then ’修改’ else ’删除’ end case) from log ????

1. case

select logid,userid,logtime,url,description,(

case

when operatetype = 0

then ’新增’

when operatetype=1

then ’修改’

else ’删除’

end ) from log

2.decode的写法:

select logid,userid,logtime,url,description,

decode(operatetype,0,’新增’,1,’修改’,’删除’) operationname

from log

建议用decode的写法

更多信息请查看IT技术专栏