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;