Oracle - 利用自带函数进行16进制与字符互转

根据16进制查字符:

select chr(to_number('2F','xx')) from dual --/

select chr(to_number('3D','xx')) from dual --=

select chr(to_number('26','xx')) from dual --&

select chr(to_number('3F','xx')) from dual --

select chr(to_number('3A','xx')) from dual --:

根据字符查16进制:

select to_char(ascii('/'),'XX') from dual --2F