汉字过滤，过滤掉所有非汉字字符。

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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/77580/viewspace-212677/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/77580/viewspace-212677/