命令oracle账号：
sqlldr userid=[USERNAME]/[PASSWORD]@[DATABASE] control=[FILEPATH]
username 用户名
password 密码
database 数据库实例
filepath ctl文件的物理路径
———————————————————————–
文件：
load datainfile *append into table [TABLENAME]fields terminated by ","trailing nullcols([ID] sequence(1,1), [COL1], [COL2], [COL3], [COL4], [COL5], [COL6])Begindatax, xx, xxx, xxxx, xxxxx, xxxxxxa, aa, aaa, aaaa, aaaaa, aaaaaa
tablename 表名
id 主键
col1,2,3,4,5,6 字段名