• 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 / RAWTOHEX Function in Oracle SQL – PLSQL

RAWTOHEX Function in Oracle SQL – PLSQL

November 27, 2012 by techhoneyadmin

The RAWTOHEX function in Oracle SQL / PLSQL is used to convert raw value to hexadecimal values.

Syntax for the RAWTOHEX function in Oracle SQL / PLSQL is:

SELECT RAWTOHEX (raw_value)
FROM table_name;


raw_value is the raw value that is to be converted to hexadecimal value.

Examples:
Using RAWTOHEX in Oracle SQL / PLSQL SELECT Statement

SELECT RAWTOHEX('A')
FROM DUAL;

Will return ‘41’ as hexadecimal value.

SELECT RAWTOHEX('AB')
FROM DUAL;

Will return ‘4142’ as hexadecimal value.

SELECT RAWTOHEX('Tech Honey')
FROM DUAL;

Will return ‘5465636820486F6E6579’ as hexadecimal value.


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

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