emp.ctl

来自「一本介绍oracle的书籍」· CTL 代码 · 共 13 行

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'
)