Thanks for the question, eva.
Asked: November 22, 2003 - 11:58 am UTC
Last updated: November 22, 2003 - 11:58 am UTC
Version: 8.0.6
Viewed 1000+ times
You Asked
Hi Tom,
I am trying to convert a string including numbers and characters
to hexadecimal.
For example: Hello World, I am 50! -----> 0110101010101
Can you help me out with either the SQL or the PL/SQL?
Thanks!
and Tom said...
that looks like binary -- but to goto hex is pretty simple:
ops$tkyte@ORA920> exec dbms_output.put_line( utl_raw.cast_to_raw( 'Hello World' ) );
48656C6C6F20576F726C64
PL/SQL procedure successfully completed.
ops$tkyte@ORA920>
you may have to install utl_raw (from $ORACLE_HOME/rdbms/admin) in 8.0
Is this answer out of date? If it is, please let us know via a Comment