oracle 按指定字符拆分字符串为数组表格StrSplit，使用背景：入参传多个编码值’111,222,333’，转换为 in (‘111’,‘222’,‘333’)

CREATE OR REPLACE FUNCTION StrSplit(p_value varchar2, p_split varchar2 := ‘,’)
return strsplit_type
pipelined is
v_index integer;
v_value varchar2(500);
v_strs_last varchar2(4000) := p_value;
begin
loop
v_index := instr(v_strs_last, p_split);
exit when v_index = 0;
v_value := substr(v_strs_last, 1, v_index - 1);
v_strs_last := substr(v_strs_last, v_index + 1);
pipe row(v_value);
end loop;
pipe row(v_strs_last);
return;
end StrSplit;