Oracle 的字符串操作

create or replace procedure test(ret out number,s out varchar2) is
str varchar2(16);
begin
str:='Mississipp+';
select INSTR(str,'+',1) into ret  from dual;
if (ret<>0) then
   select substr(str,1,length(str)-1) into s from dual;
   else
   s:='normal';
end if;

end test;