Oracle SQL 将 HEX 转换为字符

Oracle SQL convert HEX to char

提问by Oh Chin Boon

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

我试图十六进制转换为字符在甲骨文非常像这样为Microsoft SQL Server

select xx('0A') from dual;

where 0Ais hexadecimal for newline in Unix.

其中0AUnix 中的换行符是十六进制的。

回答by Bharathi

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;

回答by Kevin Burton

or

或者

SELECT ASCIISTR(CHR(TO_NUMBER('0A','xx'))) FROM DUAL

回答by CloudyMarble

Try the HEXTORAWconverion function and check the referencefor more conversion funcitons

尝试HEXTORAW转换功能并查看参考以获取更多转换功能