pb的数据窗口, 用sqlldr 创建控制文件in.ctl load data append into table TEST fields terminated by '|' ( A char(30), B char(50), C char(100), D char(20), E NUMBER )文本文件内容格式10300108200|XPB65-113S|D|0030200525 |3.42000008 10300108200|XPB65-113S|D|0030200877 |15.52000046执行sqlldr username/pw control=c:\in.ctl data=c:\in.txt
用sqlldr
创建控制文件in.ctl
load data
append
into table TEST
fields terminated by '|'
(
A char(30),
B char(50),
C char(100),
D char(20),
E NUMBER
)文本文件内容格式10300108200|XPB65-113S|D|0030200525 |3.42000008
10300108200|XPB65-113S|D|0030200877 |15.52000046执行sqlldr username/pw control=c:\in.ctl data=c:\in.txt
SQL*Loader是常用的
也可以自己编写各类程序,等等