Hier noch etwas vereinfacht:
Code:With csv2rows as (Select Element as Satz from Table(SYSTOOLS.SPLIT( GET_CLOB_FROM_FILE('/home/prouza/test.csv'), x'0D25') ) ), rows2col as (select satz, regexp_substr(satz, '[^,]+') Spalte1, regexp_substr(satz, '[^,]+', 1, 2) Spalte2, regexp_substr(satz, '[^,]+', 1, 3) Spalte3, regexp_substr(satz, '[^,]+', 1, 4) Spalte4, regexp_substr(satz, '[^,]+', 1, 5) Spalte5, regexp_substr(satz, '[^,]+', 1, 6) Spalte6 from csv2rows ) select * from rows2col;
Bookmarks