decode 与 case when then else

decode 与 case when then else
sql 语句 decode 替换
decode 用标准的CASE WHEN THEN ELSE END语句替换
Oracle 中 decode 函数用法 #
– 替换
– 采购入库单查询
decode( coalesce( i.shtxfilesid, 0 ), 0, 0, 1 ) fileflag,
（case when coalesce(i.shtxfilesid, 0) = 0 then 0 else i.shtxfilesid end) as fileflag
– 采购结算发票查询
decode(coalesce (b.uploadfilesid,0),0,0,1) uploadflag,
(case when coalesce(b.uploadfilesid,0) = 0 then 0 else b.uploadfilesid end) as uploadflag
decode(c.settletype, 1, d.sutype, 2, 4) settletype
(case when c.settletype=‘1’ then ‘1’ when d.sutype=‘2’ then ‘2’ else ‘4’ end ) as
settletype,