怎么通过日志反馈中的内容找出相应的SQL语句
2010-07-16-04.34.51.105061+480 E6805430A696 LEVEL: ErrorPID : 295074 TID : 1 &nbs...显示全部
查看其它 16 个回答nowhill的回答
to qqdzyh 二位二位转换
SQL> select to_number('C0','XXX')||'.'||to_number('A8','XXX')||'.'||to_number('72','XXX')||'.'||to_number('6E','XXX') from dual;
TO_NUMBER('C0','XXX')||'.'||TO
--------------------------------------------------------------------------------
192.168.114.110
ps一下 db2 居然没有16进制 转换成10进制的函数
SQL> select to_number('C0','XXX')||'.'||to_number('A8','XXX')||'.'||to_number('72','XXX')||'.'||to_number('6E','XXX') from dual;
TO_NUMBER('C0','XXX')||'.'||TO
--------------------------------------------------------------------------------
192.168.114.110
ps一下 db2 居然没有16进制 转换成10进制的函数
浏览1010