Advanced Search

Oracle HEXTORAW Function

/ Published in: SQL
Save to your folder(s)
A few examples of the HEXTORAW function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.