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

Question

SQL> select to_number('F','xxx') from dual; TO_NUMBER('F','XX') 
------------------- 
15

Answer 1

select to_number('12811D','xxxxxxxxxx') from dual;TO_NUMBER('12811D','XXXXXXXXXX')
--------------------------------
                         1212701已选择 1 行。

Answer 2

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

Answer 3

SQL> select to_number('FFFF','xxxxxxxxxxxxxxx') from dual;TO_NUMBER('FFFF','XXXXXXXXXXXX
------------------------------
                         65535SQL