pl/sql模拟java的split函数

create or replace procedure mysplit(s varchar2)asi number := 1;ss varchar2(10);beginloopselect regexp_substr(s,'[^,]+',1,i) into ss from dual;exit when(ss is null or length(ss) = 0);dbms_output.put_line('ss = ' || ss);i := i + 1;end loop;exceptionwhen others thendbms_output.put_line('exit now'); end;