1. oracle函数 decode代替方案
select decode(islock,'n',1,'y',2) as ab from table
select (case when isLock='N' then 1 else 2 end) as ab from table
select decode(islock,'n',1,'y',2) as ab from table
select (case when isLock='N' then 1 else 2 end) as ab from table