create or replace function(strSource in nvarchar2,strFind in nvarchar2)
return number
is
result number:=0;
begin
loop
pos1:=instr(strSource,strFind,1,result+1);
exit when pos=0;
result:=result+1;
end loop
return result;
end;
create or replace function(strSource in nvarchar2,strFind in nvarchar2)
return number
is
result number:=0;
begin
loop
pos1=instr(strSource,strFind,1,result+1);
exit when pos=0;
result=result+1;
end loop
return result;
end;