HEXTORAW(x): converts the character x containing hexadecimal digits (base 16) to a binary number (RAW) : hextoraw « Numeric Math Functions « Oracle PL / SQL
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;