oracle常用函数速记

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