Term: RAWTONHEX

Definition:
In Oracle PL/SQL, RAWTONHEX is a built in function which is used to get the hexadecimal equivalent of a raw input. Note that the returned output value is in National Character set format. It is functionally equivalent to:

TO_NCHAR(RAWTOHEX(raw_input)).

Example Syntax:

RAWTONHEX (expression)

Example Usage:

SELECT EMPNO EMPID, RAWTONHEX (EMPNO)  EMPHEX, ENAME, RAWTONHEX(ENAME) ENAME

FROM EMPLOYEE

/



EMPID EMPHEX                         ENAME      ENAME

----- ------------------------------ ---------- --------------------

  100 C202                           JOHN       4A4F484E

  110 C2020B                         KATE       4B415445

  120 C20215                         MILLER     4D494C4C4552

  130 C2021F                         JOHNY      4A4F484E59

  140 C20229                         LARRY      4C41525259

  150 C20233                         EDWIN      454457494E

  160 C2023D                         KING       4B494E47

  170 C20247                         SUEZ       5355455A

  180 C20251                         HICK       4849434B

• RAWTONHEX - RAWTONHEX converts raw to an NVARCHAR2 character value containing its hexadecimal equi...