18:44:20 jlanzpa817>create or replace function Fun_num
18:44:38 2 (v_src in varchar2,v_flag in varchar2)
18:44:38 3 return integer is
18:44:38 4 Result integer;
18:44:38 5 begin
18:44:38 6 return length(v_src) - length(replace(v_src,v_flag,''))+1;
18:44:38 7 end;
18:44:39 8 /函数已创建。已用时间: 00: 00: 00.40
18:44:39 jlanzpa817>select Fun_num('sasa,sasa,s',',') from dual;FUN_NUM('SASA,SASA,S',',')
--------------------------
3已用时间: 00: 00: 00.10
18:44:38 2 (v_src in varchar2,v_flag in varchar2)
18:44:38 3 return integer is
18:44:38 4 Result integer;
18:44:38 5 begin
18:44:38 6 return length(v_src) - length(replace(v_src,v_flag,''))+1;
18:44:38 7 end;
18:44:39 8 /函数已创建。已用时间: 00: 00: 00.40
18:44:39 jlanzpa817>select Fun_num('sasa,sasa,s',',') from dual;FUN_NUM('SASA,SASA,S',',')
--------------------------
3已用时间: 00: 00: 00.10
create or replace function Fun_num(v_src in varchar2,v_flag in varchar2) return integer is
Result integer;
begin
if v_src is null then
return 0;
end if;
return (length(v_src) - length(replace(v_src,v_flag,'')))/length(v_flag) + 1;
end;
/