创建存储过程
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, |