WITH t AS
(
SELECT '01' col1, 'text.txt' col1_text
     , '02' col2, 'aaa.jpg'  col2_text
     , ''   col3, ''         col3_text
     , '04' col4, 'mmm.ppt'  col4_text
     , ''   col5, ''         col5_text
  FROM dual
 UNION ALL
SELECT '01', 'abc.txt'
     , ''  , ''
     , '03', 'sss.txt'
     , ''  , ''
     , '05', 'yyy.txt'
  FROM dual
)
SELECT RTRIM('1.'||REGEXP_SUBSTR(f, '[^,]+', 1, 1), '1.') f1
     , RTRIM('2.'||REGEXP_SUBSTR(f, '[^,]+', 1, 2), '2.') f2
     , RTRIM('3.'||REGEXP_SUBSTR(f, '[^,]+', 1, 3), '3.') f3
     , RTRIM('4.'||REGEXP_SUBSTR(f, '[^,]+', 1, 4), '4.') f4
     , RTRIM('5.'||REGEXP_SUBSTR(f, '[^,]+', 1, 5), '5.') f5
  FROM (SELECT col1_text||','||
               col2_text||','||
               col3_text||','||
               col4_text||','||
               col5_text AS f
          FROM t
        )
;

가능한거군요....ㅜㅜ

마농님......너무 감사합니다.