SELECT REGEXP_SUBSTR('4CD1D4E27263EBBB482581ED0003B7E6,4B2A107B5BA2D3BC482581EC0003CF7C', '[^,]+', 1, LEVEL) AS NOTICE_NO
FROM DUAL
CONNECT BY REGEXP_SUBSTR('4CD1D4E27263EBBB482581ED0003B7E6,4B2A107B5BA2D3BC482581EC0003CF7C', '[^,]+', 1, LEVEL) IS NOT NULL;
按逗号分割