Oracle PL/SQL/Numeric Math Functions/hextoraw

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

   <source lang="sql">

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>

      </source>