3,491
社区成员
发帖
与我相关
我的任务
分享
create or replace function date_change(strSrc in varchar2) return varchar2 is
v_strDesc varchar2(100);
begin
for i in 1 .. length(strSrc) loop
v_strDesc := v_strDesc || case substr(strSrc, i, 1) when 1 then '壹' when 2 then '贰' when 3 then '叁' when 4 then '肆' when 5 then '伍' when 6 then '陆' when 7 then '柒' when 8 then '扒' when 9 then '玖' else '零' end case;
end loop;
return v_strDesc;
end;
create or replace function date_change(strSrc in varchar2) return varchar2 is
v_strDesc varchar2(100);
begin
for i in 1 .. length(strSrc) loop
v_strDesc := v_strDesc || case substr(strSrc, i, 1) when 1 then 壹 when 2 then 贰 when 3 then 叁 when 4 then 肆 when 5 then 伍 when 6 then 陆 when 7 then 柒 when 8 then 扒 when 9 then 玖 else '零' end case;
end loop;
return v_strDesc;
end;