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
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
)
