load data
infile "D:\data_temp\ICCG.csv"
append into table thunder2015
fields terminated by "|"
trailing nullcols
(
LATITUDE,
LONGITUDE ,
INTENS ,
SLOPE ,
ERROR ,
LOCATION ,
DATETIME timestamp "yyyy-mm-dd hh24:mi:ss",
HOUR ,
MINUTE ,
SECOND ,
MINISECOND ,
PROVINCE ,
DISTRICT ,
COUNTRY ,
INPUTTIME timestamp "yyyy-mm-dd hh24:mi:ss",
PROCESSFLAG ,
USEDIDS ,
CG_IC ,
HEIGHT
)
cmd: sqlldr user/password@database control=D:\loadctl.ctl