1.总体思路
利用tcl脚本将csv文件导入的oracle数据库表中。
2.tcl脚本
load data
infile 'csvfile.csv'
into table "tableName"
fields terminated by ','
optionally enclosed by '"'
(ID,CODE,MODIFY_TAG)
3.在oracle客户端执行语句
sqlldr userid=username/password@ip:1521/orcl control=data.ctl