外部表例子

郑全

create table extab_emp
    (last_name varchar2(30),
     salary number(10),
     hire_date date)
 organization external
    ( type oracle_loader default directory ext_dir
      access parameters
      (
         FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
         (
         LAST_NAME CHAR,
         SALARY CHAR,
         HIRE_DATE DATE "fmyyyy/mm/dd"
         )
       )
      location ('emp.dat')
     )