raw datatype include rawtohex, rawotonhex
hextoraw rawtohex and rawtonhex behave differently when executed in SQL and PL/SQL. SQL> select rawtohex('41') from dual;
3431
SQL> exec dbms_output.put_line(rawtohex('41'))
41
rawtonhex(r) is equivalent to to_nchar(rawtohex(r).