oracle_存储过程

创建存储过程

create or replace function my_split(str in varchar)
return varchar
as  
i integer := 0;
str1 varchar(1000);
begin
  i := instr(str,',',1);
  str1 := substr(str,0,i);
  return str1;
end my_split;

测试代码

select my_split('ok,test') from dual;

结果

	MY_SPLIT(‘OK,TEST’)
1	ok,