Oracle進制轉換函數

Oracle中沒有16進制轉2進制的函數，為了工作方便，自己寫了一個

create or replace function hex_to_bin(hex varchar2) return varchar2 is
  v_hex    varchar2(10000);
  v_len    number;
-
 

  v_var    varchar2(10000);
  v_result varchar2(10000) := '';
begin
  v_hex := upper(hex);
  v_len := length(v_hex);
  for i in 1 .. v_len loop
    v_var    := case substr(v_hex, i, 1) when '0' then '0000' when '1' then '0001' when '2' then '0010' when '3' then '0011'
    when '4' then '0100' when '5' then '0101' when '6' then '0110' when '7' then '0111' when '8' then '1000' when '9' then '1001'
    when 'A' then '1010' when 'B' then '1011' when 'C' then '1100' when 'D' then '1101' when 'E' then '1110' when 'F' then '1111' end;
    v_result := v_result || v_var || ' ';
  end loop;
  return v_result;
end hex_to_bin;

例子：

SQL> select hex_to_bin('0A11') from dual;

HEX_TO_BIN('0A11')

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

0000 1010 0001 0001

16進制轉10進制 ，Oracle里面有個to_number函數 可以實現
SQL> select to_number('ABC','XXX') from dual;
TO_NUMBER('ABC','XXX')
----------------------
                  2748
10進制轉16進制，ORACLE里面有個to_char函數 可以實現
SQL> select to_char('2748','XXX') from dual;
TO_CHAR('2748','XXX')
---------------------
 ABC
2進制轉10進制，ORACLE里面有個bin_to_num函數可以實現
SQL> select bin_to_num(1,1,1,1,0) from dual;
BIN_TO_NUM(1,1,1,1,0)
---------------------
 

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]