十六进制转换

一、echo
[oracle@11g ~]$ ((a=0xff))

[oracle@11g ~]$ echo $a

255

[oracle@11g ~]$

二、bc
坑爹啊

[oracle@11g ~]$ echo 'obase=10;ibase=2;111' | bc

7

[oracle@11g ~]$ echo 'ibase=2;obase=10;111' | bc

111

[oracle@11g ~]$  

三、to_number()

[oracle@11g ~]$ echo 'obase=10;ibase=16;B5FF28CC1FD' | bc

12506719109629

[oracle@11g ~]$

SQL> col aa for 9999999999999999999999999999999999

SQL> select to_number('b5ff28cc1fd','xxxxxxxxxxxxxxxxxxxxxx') aa from dual;

                                 AA

-----------------------------------

                     12506719109629

SQL>  

其他进制相似