dokuwiki

This is an old revision of the document!

---

create table ext_emp_data
 (
     vorname varchar2(100),
     nachname varchar2(100),
     gehalt number
)
organization external
   (
         type oracle_loader
         default directory system.emp_data
         access parameters
         (
               records delimited by newline
               badfile 'emp.bad'
               logfile 'emp.log'
               fields terminated by ','
               missing field values are null
               (
                      vorname,
                      nachname,
                      gehalt
         ))
             location ('emp.csv')
) reject limit unlimited;