oracle十进制函数语法,Oracle 十进制、二进制互相转换自定义函数

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