decode 함수
- if문의 효과
DECODE({column | expression}, search1, result1 [, search2, result2, ...] [, default])
예)
DECODE(SUBSTR(A.MEMNO,7,1),
'1',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('19'||SUBSTR(A.MEMNO, 1, 2))),
'2',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('19'||SUBSTR(A.MEMNO, 1, 2))),
'3',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('20'||SUBSTR(A.MEMNO, 1, 2))),
'4',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('20'||SUBSTR(A.MEMNO, 1, 2))), '0'))
if(SUBSTR(A.MEMNO,7,1) == 1)...
elseif(2)...
elseif(3)...
elseif(4)...
else...
- if문의 효과
DECODE({column | expression}, search1, result1 [, search2, result2, ...] [, default])
예)
DECODE(SUBSTR(A.MEMNO,7,1),
'1',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('19'||SUBSTR(A.MEMNO, 1, 2))),
'2',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('19'||SUBSTR(A.MEMNO, 1, 2))),
'3',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('20'||SUBSTR(A.MEMNO, 1, 2))),
'4',TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'RRRR')) - TO_NUMBER('20'||SUBSTR(A.MEMNO, 1, 2))), '0'))
if(SUBSTR(A.MEMNO,7,1) == 1)...
elseif(2)...
elseif(3)...
elseif(4)...
else...