Oracle SqlLoader

1.先將資料轉出來成txt(以 ; 分隔)
   spool c:\a.txt;
   select empno||';'||ename
   from emp;
   spool off;

2.建立一個load.ctl內容如下:
     LOAD DATA
     INFILE 'emp.csv'
     INTO TABLE emp
     FIELDS TERMINATED BY ';'
     ( empno, ename )

3.在console下:
sqlldr scott/tiger control=load.ctl log=load.log