Query to find HEX of a field in Oracle

Saturday, November 2, 2013

Query to find HEX of a field in Oracle

Some times HEX values will be useful to analyze\debug data and to find strange, unseen char issue with in a field, utl_raw.cast_to_raw is a oracle function to pull HEX values.

SQL
SELECT ENAME, utl_raw.cast_to_raw(ENAME) FROM EMP

RESULT

Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage