SELECT cp.id,cp.docstatus,
REGEXP_SUBSTR(CP.categoryids, ‘[^,]+’, 1, L) AS categoryids,cp.isdelete
FROM docbase CP,
(SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 1000)
WHERE L(+) <= LENGTH(CP.categoryids) - LENGTH(REPLACE(CP.categoryids, ‘,’)) + 1
例如:categoryids为 1,3,4
结果为:
1
3
4
1790