External Table

create directory test as 'D:/';


grant read,write on directory test to public;

create table test
(id varchar2(3),
last_name varchar2(50),
salary number
)
organization external
( default directory test
access parameters
(
fields terminated by ','
)
location ('c.txt')
)