今天在网上看到了一哥们写的取出字符串中的汉字的方法,记录下来.[@more@]
3 as
4 v_str varchar2(3000);
5 v_char varchar2(6);
6 v_result varchar2(3000);
7 begin
8 if p_str is null then
9 return null;
10 end if;
11 for i in 1..length(p_str) loop
12 v_char:=substr(p_str,i,1);
13 if lengthb(v_char)=1 then
14 v_result:=v_result||v_char;
15 end if;
16 end loop;
17 return v_result;
18 end;
19 /
Function created.
SQL> select removehanzi('where is 苏州') from dual;
REMOVEHANZI('WHEREIS苏州')
----------------------------------------------------------------------------
where is
SQL> create or replace function removehanzi(p_str varchar2)
2 return varchar23 as
4 v_str varchar2(3000);
5 v_char varchar2(6);
6 v_result varchar2(3000);
7 begin
8 if p_str is null then
9 return null;
10 end if;
11 for i in 1..length(p_str) loop
12 v_char:=substr(p_str,i,1);
13 if lengthb(v_char)=1 then
14 v_result:=v_result||v_char;
15 end if;
16 end loop;
17 return v_result;
18 end;
19 /
Function created.
SQL> select removehanzi('where is 苏州') from dual;
REMOVEHANZI('WHEREIS苏州')
----------------------------------------------------------------------------
where is
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1060219/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-1060219/