HEXTORAW function in oracle to convert hexadecimal value into a raw value.

This explains how to convert a hexadecimal value into a raw value in oracle.

There is a conversion function in oracle by the name, HEXTORAW which converts a hexadecimal value into a raw value.

Syntax: HEXTORAW (char)

Here char is the hexadecimal value that needs to be converted to the raw value.

Ex1: SELECT HEXTORAW('123') FROM dual;
This returns a “0123” as result.

Ex2: SELECT HEXTORAW('12AB') FROM dual;
This returns “12AB'” as result.