用SQL*LOADER导入EXCEL文件一般转化成CSV文件后再导入,需要注意两点:
(1).CSV文件的字段分隔符为逗号
(2).CSV文件定界符为双引号
LOAD DATA
INFILE 'E:\Test.csv'
INTO TABLE BONUS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(ENAME,JOB,SAL)
用SQL*LOADER导入EXCEL文件一般转化成CSV文件后再导入,需要注意两点:
(1).CSV文件的字段分隔符为逗号
(2).CSV文件定界符为双引号
LOAD DATA
INFILE 'E:\Test.csv'
INTO TABLE BONUS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(ENAME,JOB,SAL)