• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / HEXTORAW Function in Oracle SQL – PLSQL

HEXTORAW Function in Oracle SQL – PLSQL

November 7, 2012 by techhoneyadmin

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:

SELECT HEXTORAW('90A')
FROM DUAL;

Will return ‘090A’ as raw value.


Example 2:

SELECT HEXTORAW('00F')
FROM DUAL;

Will return ‘000F’ as raw value.


Filed Under: function Tagged With: hextoraw function in oracle plsql, hextoraw function in oracle sql, HEXTORAWPLSQL, how to use hextoraw function in oracle database query, how to use hextoraw function in oracle plsql, how to use hextoraw function in oracle sql, syntax and example of hextoraw function in oracle database query, syntax and example of hextoraw function in oracle plsql, syntax and example of hextoraw function in oracle sql, using hextoraw function in oracle database query, using hextoraw function in oracle plsql, using hextoraw function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in