Monday, 20 July 2015

How to Convert Comma Separated Values into Table using 'REGEXP_SUBSTR'

WITH csv
     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;

No comments:

Post a Comment

How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...