Oracle 的sql语句多条件判断

就需要多条件下面是一个多条件判断的sql：

Sql代码

1. select
2. oper.opid,
3. oper.user_name,
4. oper.user_host,
5. case
6. when oper.oper_type = 1 then'System Manager'
7. when oper.oper_type = 2 then'USER Manager'
8. end case,
9. case
10. when oper.oper_object_type = 1 then 'User'
11. when oper.oper_object_type = 2 then 'Role'
12. when oper.oper_object_type = 3 then 'Broker'
13. when oper.oper_object_type = 4 then 'QM Manager'
14. when oper.oper_object_type = 5 then 'User Group'
15. when oper.oper_object_type = 6 then 'Msg Flow'
16. when oper.oper_object_type = 7 then 'Queue'
17. end case
19. from esb_log_user_oper oper;

select         oper.opid,        oper.user_name,        oper.user_host,        case         when oper.oper_type = 1  then 'System Manager'         when oper.oper_type = 2  then 'USER Manager'        end case,        case        when oper.oper_object_type = 1 then 'User'        when oper.oper_object_type = 2 then 'Role'        when oper.oper_object_type = 3 then 'Broker'        when oper.oper_object_type = 4 then 'QM Manager'        when oper.oper_object_type = 5 then 'User Group'        when oper.oper_object_type = 6 then 'Msg Flow'        when oper.oper_object_type = 7 then 'Queue'        end case      from esb_log_user_oper oper;