2011年8月30日 星期二

SQL*Loader基本用法

指令:
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
"10014","Frank Naude","500",20

參考:
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