ORACLE里面如何写CASE语句
类别: 数据库教程 
如下：
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
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
- 上一篇: SQL中的两个值得注意的特殊符号
- 下一篇: SQL语法速成
