오라클 base64 암호화 및 복호화

암호화

SELECT UTL_ENCODE.TEXT_ENCODE('12345', 'KO16KSC5601', 1) AS ENCODED_VAL      FROM DUAL;

 

복호화

SELECT UTL_ENCODE.TEXT_DECODE('MTIzNDU=', 'KO16KSC5601', 1) AS ENCODED_VAL      FROM DUAL;