DEV Community

Fatih Şahin
Fatih Şahin

Posted on • Updated on

Oracle REGEXP_SUBSTR Function

#uyumsoft 
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
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

mikeyoung44 profile image

Unlocking Trillion-Token LLMs with FP8 Precision: Defeating Outlier Amplification

Mike Young -

codenextgen profile image

Express for Beginners: Create Your First Web App Today

codenextgen -

nne profile image

Provide Storage For The IT Department Testing And Training.

Blessing -

marioflores7 profile image

Applying the Data Mapper Pattern in a Real-World Application

Marant7 -