SQL*LOADER

sqlldr user/pass@host control=./***.ctrl log=./sqldrl.log

LOAD DATA

CHARACTERSET JA16SJIS

INFILE './***.csv'

INTO TABLE テーブル名

APPEND

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(

カラム定義,

date DATE "YYYY/MM/DD HH24:MI:SS",

・・・,

・・・

)