17,090
社区成员
发帖
与我相关
我的任务
分享
-- 楼主先搜索一下,有了具体问题再问吧,这次给你写出来
SQL> begin
2 for x in (select regexp_substr('AAA,BB,FF,DDDD','[^,]+',1,level) item
3 from dual
4 connect by rownum <= regexp_count('AAA,BB,FF,DDDD',',')+1
5 ) loop
6
7 dbms_output.put_line(x.item);
8 end loop;
9 end;
10 /
AAA
BB
FF
DDDD
PL/SQL procedure successfully completed
SQL>