oracle decode用法简介
SELECT DECODE(比较项,条件一,返回一,条件二,返回二,否则返回值) AS NAME FROM DUAL
SELECT DECODE(‘1’,‘1’,‘Y’,‘2’,‘N’,‘NULL’) AS NAME FROM DUAL —‘Y’
SELECT DECODE(‘2’,‘1’,‘Y’,‘2’,‘N’,‘NULL’) AS NAME FROM DUAL —‘N’
SELECT DECODE(‘3’,‘1’,‘Y’,‘2’,‘N’,‘NULL’) AS NAME FROM DUAL —‘NULL’