/ Published in: SQL
A few examples of the HEXTORAW function.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
--HEXTORAW SELECT '69FE56', utl_raw.cast_to_varchar2('69FE56') AS converted_string FROM dual; --Example 1 SELECT HEXTORAW('0F') AS hexval FROM dual; --Example 2 SELECT '0CF2', HEXTORAW('0CF2') AS hexval FROM dual;
URL: http://www.databasestar.com/oracle-hextoraw/