Oracle PL/SQL/Numeric Math Functions/hextoraw

HEXTORAW(x): converts the character x containing hexadecimal digits (base 16) to a binary number (RAW)

SQL>
SQL> --HEXTORAW(x) Converts the character x containing hexadecimal digits (base 16) to a binary number (RAW).
SQL>
SQL> select hextoraw("45D") from dual;
HEXT
----
045D
SQL>