String to Hex // Hex to String

오라클에서의 String to Hex 및 Hex to String 함수

 

String to Hex

SELECT TO_CHAR(RAWTOHEX('1J4FJ28P8PL586090')) FROM DUAL;

==========================================================================================

Hex to String
SELECT UTL_RAW.CAST_TO_VARCHAR2('314A34464A32385038504C353836303930') FROM DUAL