CASE 와 DECODE
case절과 decode절의 문법차이 SELECT empno , ename , sal , CASE job WHEN 'SALESMAN' THEN 1.10 * sal WHEN 'PRESIDENT' THEN 1.15 * sal WHEN 'MANAGER' THEN 1.20 * sal ELSE sal END revised_sal FROM EMP; SELECT empno , ename , sal , DECODE(job, 'SALESMAN', 1.10 * sal , 'PRESIDENT', 1.15 * sal , 'MANAGER', 1.20 * sal , sal) revised_sal FROM EMP; ex> ,DECODE(C.SE_RST_SCD,'420','','431','',SUBSTR(C.SE_RST_SCD,1,..
더보기