Listing A: Defining an Oracle external table

create table

   emp_ext

(

   empno    number(4),

   ename    varchar2(10),

   job      varchar2(9),

   mgr      number(4),

   hiredate date,

   sal      number(7,2),

   comm     number(7,2),

   deptno   number(2)

)

organization external

(

   type oracle_loader

   default directory testdir

   access parameters

   (

      records delimited by newline

      fields terminated by ‘,’

   )

location (‘emp_ext.csv’)

)

reject limit 1000;