oracle_16進制與10進制轉換小示例

--16進制轉10進制,用to_number,裡面的參數是16進制的資料,且參數用單引号括起

SQL> select to_number('ff','xx') from dual;

TO_NUMBER('FF','XX')

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

                 255

--10進制轉16進制,用to_char,裡面的參數是10進制的資料,且參數不用單引号括起

SQL> select to_char(255,'xx') from dual;

TO_CHAR(255,'XX')

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

 ff

--如下報錯因為要轉換的16進制的資料寬度與格式串的xx寬度不一樣

SQL> select to_number('10effff','xx') from dual;

select to_number('10effff','xx') from dual

ORA-01722: 無效數字

--續上,修正二者寬度一緻,不再報錯

SQL> select to_number('10effff','xxxxxxx') from dual;

TO_NUMBER('10EFFFF','XXXXXXX')

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

                      17760255

--格式串的寬度>=要轉化的資料寬度也可以

SQL> select to_number('e','xxxxxxx') from dual;

TO_NUMBER('E','XXXXXXX')

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

                      14