幕布斯6054654
使用SQL*Loader。这需要一些设置,但如果这不是一次性的,这是值得的。创建表SQL> create table ldr_test (id number(10) primary key, description varchar2(20));Table created.SQL>创建CSVoracle-2% cat ldr_test.csv1,Apple2,Orange3,Pear
oracle-2%创建装载机控制文件oracle-2% cat ldr_test.ctl
load data
infile 'ldr_test.csv'
into table ldr_test
fields terminated by "," optionally enclosed by '"'
( id, description )oracle-2%运行SQL*Loader命令oracle-2% sqlldr control=ldr_test.ctl
Password:SQL*Loader: Release 9.2.0.5.0 - Production on Wed Sep 3 12:26:46 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Commit point reached - logical record count 3确认插入SQL> select * from ldr_test;
ID DESCRIPTION---------- --------------------
1 Apple 2 Orange 3 Pear
SQL>SQL*Loader有很多选项,并且几乎可以接受任何文本文件作为它的输入。如果需要,甚至可以将数据内联到控制文件中。这里有一个包含更多细节的页面->SQL*Loader