[ORACLE] External table

1. Make directory

create directory [dir_nm] as '[dir_path]';

2. Make table

create table [table_name]
(
 column1 char(10)
,column2 char(10)
)
organization external
(
 type oracle_loader
default directory [dir_nm]
access parameters(
records delimited by newline
fields terminated by ';'(
column1 char,
column2 char))
location('[file_name]'))
;