emp.ctl

一本介绍oracle的书籍

load data
append
into table emp
fields terminated by '|'
(
    no		float external,
    name	char(20),
    age		integer external,
    duty	char(1),
    salary	float external,
    upd_ts	date(14) 'YYYYMMDDHH24MISS'
)