create directory DIR as 'D:\'

create table emp_ext3
(empno number(4)
,ename varchar2(50)
,job number(10)
)
organization external
(
type oracle_loader
default directory DIR
 access parameters
    (records delimited by newline
     fields terminated by ','
     )
     location ('emp.txt')
     )

select * from emp_ext3