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----------------------------------------------...
显示全部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进制的函数
收起