【case when】mysql的casewhen语句转oraclewhere子句条件如下:where....

【case when】mysql的casewhen语句转oraclewhere子句条件如下:where....

【答案】 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 -- (根据反回结果来过滤数据）

我好好复习下