External Table in Oracle

Sample script to create an external table in Oracle PL/SQL
-----------------------------------------
CREATE TABLE xx_ITEMS
(
COPY_ITEM VARCHAR2(40 BYTE),
ITEM VARCHAR2(40 BYTE),
DESCRIPTION VARCHAR2(240 BYTE),
PRIMARY_UOM VARCHAR2(25 BYTE),
ITEM_TYPE VARCHAR2(30 BYTE),
MAKE_BUY VARCHAR2(10 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY TOHOST
ACCESS PARAMETERS
( records delimited BY newline
skip 1
badfile temp:'xx_items%p.bad'
logfile temp:'xx_items%p.log'
fields terminated BY ','
optionally enclosed BY '"'
missing field VALUES ARE NULL
)
LOCATION (TOHOST:'xx_items.csv')
)
REJECT LIMIT 0
NOPARALLEL
NOMONITORING;