oracle怎么把数字转换成二进制

显示全部楼层 · 2013-1-25 12:24:13

创建存储过程create or replace function f_dec_to_bin(v_num number) return varchar isv_rtn varchar(2000);v_n1 number;v_n2 number;beginv_n1 := v_num;loop
v_n2 := mod(v_n1, 2);
v_n1 := trunc(v_n12);
v_rtn := to_char(v_n2) || v_rtn;
exit when v_n1 = 0;end loop;return v_rtn;end f_dec_to_bin;然后用select f_dec_to_bin(5) from dual;得到转换后的值或者在PLSQL中直接用f_dec_to_bin函数赞同0|评论