Oracle SQL convert HEX to char

Question

i am trying to convert a hexadecimal to character in Oracle ideally something like this for Microsoft SQL Server

select xx('0A') from dual;

where 0A is hexadecimal for newline in Unix.

Answer 1

Try

SELECT UTL_I18N.RAW_TO_CHAR (<string>, <src_char_set>) FROM DUAL; 

For example,

SELECT UTL_I18N.RAW_TO_CHAR ('0A', 'AL32UTF8') FROM DUAL;