Oracle sqlldr导入一个日期列实例详解

oracle sqlldr导入一个日期列实例详解

1.

load data
infile *
into table test
fields terminated by x'9'
trailing nullcols
(
 c2 "upper(:c2)",
 c3 date "yyyymmdd",
 c1 "seq_test_c1.nextval"
)
begindata
aaaaaaaaaa 20051201
bbbbbbbbbb 20050112

create table test
(
 c1 varchar2(10 byte),
 c2 varchar2(20 byte),
 c3 date
);

create sequence vv_user.seq_test_c1
start with 0
maxvalue 9999999
minvalue 0
nocycle
nocache
noorder;

　sqlldr user/passwd control = load_date.ctl

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！