17,086
社区成员
发帖
与我相关
我的任务
分享
with t as(select '{{{111,222,333,444,555,666},{777,888,999,aaa,bbb,ccc},{ddd,eee,fff,ggg,hhh,iii}}}' str from dual)
select regexp_replace(str,'{+([^,]+,){3}([^,]+,)[^,]+,([^,}]+)}+','\2\3')
from t
结果形式如下:
444,666,aaa,ccc,ggg,iii