SELECT
trim(regexp_substr(FFD.ZZ_INVOICE_M_ID, '[^,]+', 1, lines.column_value)) AS INVOICE_M_ID
FROM FINT_FIN_D FFD,TABLE(CAST (MULTISET(SELECT LEVEL FROM DUAL CONNECT BY INSTR(FFD.ZZ_INVOICE_M_ID, ',', 1, LEVEL - 1) > 0) AS sys.odciNumberList )) lines
WHERE NULLIF(TO_CHAR(FFD.ZZ_INVOICE_M_ID),TO_CHAR('0')) IS NOT NULL
ORDER BY lines.column_value
Oracle REGEXP_SUBSTR Function
Fatih Şahin - Jun 14 '23 - 
