Posted By

bbrumm on 02/15/17


Tagged

sql Oracle


Versions (?)

Oracle HEXTORAW Function


 / Published in: SQL
 

URL: http://www.databasestar.com/oracle-hextoraw/

A few examples of the HEXTORAW function.

  1. --HEXTORAW
  2.  
  3. SELECT '69FE56',
  4. utl_raw.cast_to_varchar2('69FE56') AS converted_string
  5. FROM dual;
  6.  
  7.  
  8. --Example 1
  9. SELECT HEXTORAW('0F') AS hexval
  10. FROM dual;
  11.  
  12. --Example 2
  13. SELECT '0CF2', HEXTORAW('0CF2') AS hexval
  14. FROM dual;

Report this snippet  

You need to login to post a comment.