请问如何用sql实现字符型十六进制如何转换成十进制？？？

[reggean]

请问如何用sql实现字符型十六进制如何转换成十进制？？？

如：12811D

[freddy2003]

SQL> select to_number('F','xxx') from dual;

TO_NUMBER('F','XX')
-------------------
15

[freddy2003]

select to_number('12811D','xxxxxxxxxx') from dual;

TO_NUMBER('12811D','XXXXXXXXXX')
--------------------------------
1212701

已选择 1 行。

[dinya2003]

select to_number('F','xxx') from dual
OK?

[fakefakir]

IP字符串怎么转化？

[wolfAone]

SQL> select to_number('FFFF','xxxxxxxxxxxxxxx') from dual;

TO_NUMBER('FFFF','XXXXXXXXXXXX
------------------------------
65535

SQL