指令:
sqlldr username/password control=loader.ctl DIRECT=TRUE
loader.ctl:
load data infile 'd:\work\mydata.csv' append into table SPECIAL_PRODUCT fields terminated by "," optionally enclosed by '"' ( UUID, PROD_NO, PROD_NAME, PRICE ) |
mydata.csv:
"10013","Scott Tiger","1000",40 |
參考:
http://www.orafaq.com/wiki/SQL*Loader_FAQ
EnterpriseDB對應的工具是EDB*Loader:
http://www.enterprisedb.com/docs/en/8.4/oracompat/Postgres_Plus_Advanced_Server_Oracle_Compatibility_Guide-191.htm