create function replace_num(p_num number)
return varchar2
is
v_num varchar2(100);
begin
for i in 1..length(p_num) loop
if substr(p_num,i,1)=0 then
v_num:=v_num||'$';
else
v_num:=v_num||'#';
end if;
end loop;
return v_num;
end;
/
select replace_num(col) from table_name;
return varchar2
is
v_num varchar2(100);
begin
for i in 1..length(p_num) loop
if substr(p_num,i,1)=0 then
v_num:=v_num||'$';
else
v_num:=v_num||'#';
end if;
end loop;
return v_num;
end;
/
select replace_num(col) from table_name;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货