以下语句是否可以转换为decode函数:case when subjcode like '6601%' or subjcode like '6602%' or subjcode like '6603%' then subjcode else 'N/A' end
以下语句是否可以转换为decode函数:case when subjcode like '6601%' or subjcode like '6602%' or subjcode like '6603%' then subjcode else 'N/A' end
(case when col_name=1 then 'OK' when col_name=2 then 'Faild' else 'Un Now' end)-- 可以替换为:
decode(col_name,1,'OK',2,'Faild','Un Now')
case when subjcode like '6601%' or subjcode like '6602%' or subjcode like '6603%' then subjcode else 'N/A' end-- 要用decode的话,也只能借助substr()函数,这样写:
decode( substr(subjcode,1,4),'6601',subjcode,'6602',subjcode,'6603', subjcode, 'N/A')
decode(regexp_instr(subjcode,'^[6601|6602|6603]')-1,0,subjcode,-1,'N/A')
修正decode(regexp_instr('67010a','^660[1|2|3]')-1,0,subjcode,-1,'N/A')