Search notes:

Oracle SQL functions that are related to RAWs

Some Oracle SQL functions that are related to the raw datatype include

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).

See also