正则表达式问题

regonly1

跟9楼的类似，取法稍有差别：
SQL> select regexp_substr('["a","b"],["c","d"]','\[[^[]+\]',1,rownum) from dual connect by rownum <= 2
  2  /
REGEXP_SUBSTR('["A","B"],["C",
--------------------------------------
["a","b"]
["c","d"]

zxy877298415

select replace(replace('["a","b"],["c","d"],["e","f"],["g","h"]','],[',']@@@['),'@@@',chr(10)) a from dual;