Oracle sqlldr导入一个日期列实例详解
程序员文章站
2022-04-03 20:29:28
oracle sqlldr导入一个日期列实例详解
1.
load data
infile *
into table test
fields termina...
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
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!