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
?