Oracle External table example

1) Create the operating system directory e:/test,parse data file dept.txt and place it under E:/test "10", "accounting", "New York"
"20", "research", "Dallas"
"30", "sales", "Chicago"
"40", "operations", "Boston"
2) Create the database directory object e_testcreate directory e_test as 'e:/test'; 3) define the External table create table new_dept (deptno number (2)
, Dname varchar2 (14)
, Loc varchar2 (13 ))
Organization external (type oracle_loader
Default directory e_test
Access parameters (records delimited by newline
Badfile 'dept. bad'
Discardfile 'dept. DSC'
Logfile 'dept. Log'
Fields terminated ','
Optionally enclosed '"'
Missing field values are null)
Location('dept.txt '); 4) Verify (query is supported, but DML is not supported for write operations) Select * From new_dept;