Load CSV data to a table

set echo on
create table dept
( deptno  number(2),
  dname   varchar2(14),
  loc     varchar2(13)
)
/

LOAD DATA
INFILE *
INTO TABLE DEPT
FIELDS TERMINATED BY ','
(DEPTNO,
  DNAME,
  LOC
)
BEGINDATA
10,Sales,BC
20,Accounting,BC
30,Consulting,BC
40,Finance,BC

drop table dept;