Oracle截取字符串进行循环

Oracle截取字符串进行循环

存储过程

create or replace procedure PRO_FOR_TEST is
       v_temp_name varchar2(4000);
begin
       v_temp_name := '杰克、克拉克、托尼、莉莉';
       --循环开始
       for e in (select column_value from table(strsplit(v_temp_name, '、'))) loop
                dbms_output.put_line(e.column_value);
      --循环结束
      end loop;
end PRO_FOR_TEST;

测试

begin
  -- Call the procedure
  pro_for_test;
end;