17,377
社区成员
发帖
与我相关
我的任务
分享
with T AS(
select ROWID ID,REGEXP_SUBSTR(A, '1[3|5|7|8|][0-9]{9}', 1, LEVEL) A
from TABLE1
CONNECT BY LEVEL <= REGEXP_COUNT(A, '1[3|5|7|8|][0-9]{9}')
and rowid= prior rowid
and prior dbms_random.value is not null;
)
SELECT WMSYS.WM_CONCAT(A)
FROM T
GROUP BY ID