sql loader实例
创建表：test_load，sql>create table test2(empno number(10),ename varchar2(12),sal number(10),deptno number(10));
控制文件：c:\loader.ctl
load data
infile 'c:\datafile.txt'
append into table test2
fields terminated by "," optionally enclosed by '"'
( empno, ename, sal, deptno )
数据文件：c:\datafile.txt
10002,"Frank", 500, 20
10001,"Scott", 1000, 40
sqlloader命令：
sqlldr scott/tiger control=c:\loader.ctl log=a.log
SQL> select * from test2;
EMPNO ENAME SAL DEPTNO
---------- ---------- ---------- ----------
10002 Frank 500 20
10001 Scott 1000 40
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10225874/viewspace-566822/ ，如需转载，请注明出处，否则将追究法律责任。
