mysql的case when语句转oracle

oracle也有case when的语法，照办就行，不过用在where条件中，需要有返回值的比较.
这是根据你提供的语句修改，给你提供一个参考吧：
where a.xxx = 'asdf' and (
case
when (b.i like '%0%') then true
when (b.i like '%1%') and c.creatorCode = #code# then true
when (b.i like '%2%') and (d.createDept = #dept# and #flag# = 1) then true
else false
end) = true
这是按照我的业务理解写的
where a.xxx = 'asdf' and (
case
when (b.i like '%0%') then 1
when (b.i like '%1%') and c.creatorCode = #code# then 2
when (b.i like '%2%') and (d.createDept = #dept# and #flag# = 1) then 3
else 4
end) = 1 -- (根据反回结果来过滤数据）

mysql不熟

- -! 不知道你说啥 d.createDept = #dept# and #flag# = 1 能对么。。。