How to Convert Comma Separated Values into Table using ‘REGEXP_SUBSTR.’

Introduction

This Post is about to  Convert Comma Separated Values into Table using

WITH CSV’ REGEXP_SUBSTR.’

AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL)

SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char

FROM DUAL, csv

CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+’, 1, LEVEL) IS NOT NULL;

Summary

This Post described about connected by REGEXP_SUBSTR(CSV>csvdata,'[^,]+’,1,LEVEL) IS NOT NULL:  in Oracle EBS R12.

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.