Question

求把oracle导出的TXT文件导入到SQL的C#代码

ORACLEDUMP |SETID YEAR ID SID EID IID BAL00 BID ISPLAN
"2","2008","1","101.1."," "," ","723191050.39","","0"
"2","2008","2","102.10."," "," ","4224111.02","","0"
"2","2008","3","102.11."," "," ","448808.34","","0"
"2","2008","4","102.13."," "," ","3120","","0"
"2","2008","5","102.14."," "," ","15017212.5","","0"
"2","2008","6","102.7."," "," ","14895845.63","","0"
"2","2008","7","102.8."," "," ","37705436.86","","0"
"2","2008","8","102.9."," "," ","41949370.34","","0"

oracle导出的TXT文件格式如上。
TXT文件是别人拿过来的，因此要对TXT文件进行处理，把前面的“ORACLEDUMP |”去掉，再把后面那段当成表的列名，由于有事列名不一样，不能用固定列名，只能用数组或其他方法读取。
每一行最后都有换行符，能分清行。

Answer 1

1.写控制文件格式如下（下面是我自己的，你把表名该成你自己的表，字段该成你的字段就可以了）：
OPTIONS (skip=0,rows=128)
load data
INFILE "user_user_test.txt"
into table USER_USER_TEST
truncate
fields terminated by ',' optionally enclosed by '"'
(
USERID,
CITYID,
USERNAME,
PWD,
CREATETIME
)
2.把控制文件和数据文件放在同一个目录（建议）
3.执行sqlldr userid=scott/anwei@orcl control=user_user_test.ctl data=user_user_test.txt log=user_user_test.log 命令