1.介绍
-- sqlldr代表sql loader,sqluldr代表sql unloader
-- cmd输入sqlldr/sqluldr可查看帮助,讲的很明白
2.sqlldr举例
- 创建控制文件input.ctl
-- 写法和mysql的load data命令比较像
load data
infile 'f:\work\data.csv'
append into table table_name
fields terminated by ','
lines terminated by '0x0a'
(c1,c2)
- cmd中输入:
-- skip n代表忽略前n行,1是忽略标题,不写在ctl文件中
sqlldr user/pwd control = 'f:\work\input.ctl' skip = 1
3.sqluldr2举例
-- user = username/pwd@tnsname
-- head = yes,导出表头
sqluldr2 user=wll/22@xe head=yes field=0x2c record=0x0d query="select * from test" file="f:\work\test.csv"