CREATE table employees_ext (
        employee_id NUMBER(5),
        first_name varchar2(30),
        last_name varchar2(30),
        email varchar2(30)
        )
ORGANIZATION EXTERNAL  -- External Table
(
  TYPE oracle_loader    -- Access Driver
  DEFAULT DIRECTORY demo_dir -- Files Directory
  ACCESS PARAMETERS -- Similar to SQL*Loader
 (
 RECORDS DELIMITED BY NEWLINE
 BADFILE 'bad_sample'
 LOGFILE 'log_sample'
 FIELDS TERMINATED BY ','
 MISSING FIELD VALUES ARE NULL
 )
 LOCATION ('Employees.csv')
)
PARALLEL 1 -- Independent from the number of files
REJECT LIMIT UNLIMITED;