案例:
Select decode(columnname,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)
From talbename
Where …
实际应用
decode(cxcygzcg, '', 0, null, 0, cxcygzcg) cxcygzcg
案例:
Select decode(columnname,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)
From talbename
Where …
实际应用
decode(cxcygzcg, '', 0, null, 0, cxcygzcg) cxcygzcg