emp2.ctl

一本介绍oracle的书籍

load data
infile *
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'
)
begindata
100000000003|Mulder|000020|1|000000005000|20020101000000
100000000004|Scully|000025|2|000000008000|20020101235959