create or replace
FUNCTION "TENTOBIN" (ix IN NUMBER) RETURN VARCHAR2
IS
vars VARCHAR2(1000);
xs NUMBER(10);
BEGIN
vars:='';
xs:=ix;
WHILE xs>0 LOOP
vars:=cast(MOD(xs,2) as VARCHAR2)||vars;--拼接字符串用“||”
xs:=FLOOR(xs/2);
END LOOP;
RETURN vars;
END TENTOBIN;
oracle数据库十进制转二进制
最新推荐文章于 2021-04-03 11:47:21 发布