EXTERNAL_TABLE:
-----------------------
create or replace directory external_test as '/tmp';
create table test
(day_ varchar2(10),
 splr varchar2(20),
 wh__ varchar2(20),
 skps varchar2(20),
 val number)
organization external
(type oracle_loader default directory external_test
 access parameters
 (
  records delimited by newline
  fields terminated by whitespace
  (day_ char,
   splr char,
   wh__ char,
   skps char,
   val float external
  )
 )
 location ('test.txt')
)
reject limit unlimited;

-------------------------------

CREATE TABLE all_objects_html
  ORGANIZATION EXTERNAL
    (
    TYPE ORACLE_DATAPUMP
    DEFAULT DIRECTORY xtern_data_dir
    LOCATION ( 'all_objects_xt.html' )
    )
  AS
    SELECT *
    FROM  all_objects;

-------------------------------------------------------------

CREATE TABLE External_Table_HR
(
  S_NUMBER  VARCHAR2(8 BYTE),
  NAME            VARCHAR2(100 BYTE),
  SEX             VARCHAR2(2 BYTE),
  DEPTID          VARCHAR2(6 BYTE),
  DEPT_DESCR      VARCHAR2(100 BYTE),
  GEO_LOCATION    VARCHAR2(100 BYTE),
  DESCR           VARCHAR2(100 BYTE),
  FULL_PART       VARCHAR2(1 BYTE),
  STD_HRS_WK      NUMBER,
  GRADE           VARCHAR2(30 BYTE),
  GRADE_DESCR     VARCHAR2(30 BYTE),
  DATA_DATE       DATE
)
ORGANIZATION EXTERNAL
  (  TYPE ORACLE_LOADER
     DEFAULT DIRECTORY DATA_DIR
     ACCESS PARAMETERS
       ( records delimited by newline
  NOLOGFILE
  BADFILE DATA_DIR:'EXTHR.bad'
  skip 1
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
   )
     LOCATION (DATA_DIR:'EXTHR.csv')
  )
REJECT LIMIT 0
LOGGING
NOCACHE
NOPARALLEL;