create or replace function f_hanzi_filter
(v_hanzi nvarchar2) return nvarchar2 is
v_filted nvarchar2(1000);
m_length integer;
m_single_hanzi nvarchar2(2);
m_count integer;
begin
m_length:=length(v_hanzi);
v_filted:='';
if v_hanzi is null then
return '*';
end if;
for i in 1..m_length loop
m_single_hanzi:=substr(v_hanzi,i,1);
select count(*)
into m_count
from t_py_char s
where s.hanzi like '%'||m_single_hanzi||'%';
if m_count>0 then
v_filted:=v_filted||m_single_hanzi;
else
return (v_filted);
end if;
end loop;
return(trim(v_filted));
exception
when others then
return(null);
end ;
(v_hanzi nvarchar2) return nvarchar2 is
v_filted nvarchar2(1000);
m_length integer;
m_single_hanzi nvarchar2(2);
m_count integer;
begin
m_length:=length(v_hanzi);
v_filted:='';
if v_hanzi is null then
return '*';
end if;
for i in 1..m_length loop
m_single_hanzi:=substr(v_hanzi,i,1);
select count(*)
into m_count
from t_py_char s
where s.hanzi like '%'||m_single_hanzi||'%';
if m_count>0 then
v_filted:=v_filted||m_single_hanzi;
else
return (v_filted);
end if;
end loop;
return(trim(v_filted));
exception
when others then
return(null);
end ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/77580/viewspace-212677/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/77580/viewspace-212677/