1.截断中文字符串
CREATE OR REPLACE function cn_cutstr(v_str varchar2,v_len number)
return varchar2
IS
v_i number(10);
BEGIN
v_i:=v_len;
loop
exit when(lengthb(substr(v_str,1,v_i)) <= v_len);
v_i := v_i-1;
end loop;
return substr(v_str,1,v_i);
end cn_cutstr;
收藏于 2014-12-03
来自于百度空间