Advanced Search

Return to Snippet

Revision: 71302
at February 15, 2017 05:20 by bbrumm
Initial Code 
--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;
Initial URL 
http://www.databasestar.com/oracle-hextoraw/
Initial Description 
A few examples of the HEXTORAW function.
Initial Title 
Oracle HEXTORAW Function
Initial Tags 
sql, Oracle
Initial Language 
SQL