The HEXTORAW function in Oracle SQL / PLSQL is used to convert hexadecimal values to raw values.
Syntax for the HEXTORAW function in Oracle SQL / PLSQL is:
SELECT HEXTORAW(hexa_decimal_value)
FROM table_name;
- hexa_decimal_value is the hexadecimal value that is to be converted to raw value.
Example 1:
1 | SELECT HEXTORAW('90A') |
2 | FROM DUAL; |
Will return ‘090A’ as raw value.
Example 2:
1 | SELECT HEXTORAW('00F') |
2 | FROM DUAL; |
Will return ‘000F’ as raw value.