在查看apache log时,经常在url里面混杂着%3a,%2f等字符,究竟代表什么?只需通过oracle自带函数转换下就可。
根据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
,
