Database
[ORACLE] CASE WHEN THEN, DECODE
애플자라
2007. 12. 27. 08:56
반응형
CASE
WHEN STDAY IN ('1900-01-01','3000-01-01') THEN NULL
ELSE TO_CHAR(ENDDAY,'YYYY')||'-'||TO_CHAR(ENDDAY,'MM')||'-'||TO_CHAR(ENDDAY,'DD') END AS ENDDAY, --만기일
===================================================================================
DECODE(MMGG,'0','',TO_CHAR(MMGG,'9,999,999,999,999')) AS MMGG
WHEN STDAY IN ('1900-01-01','3000-01-01') THEN NULL
ELSE TO_CHAR(ENDDAY,'YYYY')||'-'||TO_CHAR(ENDDAY,'MM')||'-'||TO_CHAR(ENDDAY,'DD') END AS ENDDAY, --만기일
===================================================================================
DECODE(MMGG,'0','',TO_CHAR(MMGG,'9,999,999,999,999')) AS MMGG
반응형