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
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!
如对本文有疑问, 点击进行留言回复!!
Windows10安装Oracle19c数据库详细记录(图文详解)
Oracle用decode函数或CASE-WHEN实现自定义排序
Oracle利用errorstack追踪tomcat报错ORA-00903 无效表名的问题
网友评论