Oracle 十进制、二进制相互转换自定义函数

create or replace function number_2_bit(v_num number) return varchar is  v_rtn varchar(2000);  v_n1 number;  v_n2 number;begin  v_n1 := v_num;  loop    v_n2 := mod(v_n1, 2);    v_n1 := trunc(v_n1 / 2);    v_rtn := to_char(v_n2) || v_rtn;    exit when v_n1 = 0;  end loop;  return v_rtn;end;


sql> select bit_2_number('10001100000000011001111111111') from dual;
------------------------------
  293614591

 

create or replace function bit_2_number(v_char varchar) return number is 
  v_rtn number(10);  v_n1 number;  v_n2 number;
Begin 
  Select sum (data1) Into v_rtn From (select substr (v_char,rownum,1)*                                          power(2,length(v_char)-rownum) data1 
  From dual
  Connect by rownum<=length(v_char) ;
  Return v_rtn;
End;      

sql> select number_2_bit(571231007) from dual;
------------------------------
100010000011000100101100011111