HEXTORAW

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

SQL> select hextoraw('7E') from dual;

HE
--
7E

SQL>