Control file name INPUT.CTL
Load DataInfile 'ddxx00000000.yc'Replace INTO TABLE TRAIN_INFO // Replace For replacement of data, append is inserted into new data fields terminated by', 'optionally enclosed' "'// fields tembletribed by'," that is, the separator is comma " 'i.e. with the string field" due to. (train_no, seq_no, station_name, map_on_date, map_on_time, map_off_date, map_off_time, plan_on_date, plan_on_time, plan_off_date, plan_off_time, real_on_date, real_on_time, real_off_date, real_off_time)
Use the SQL statement in the command line:
SQLLDR Userid = UserName / Password Control = INPUT.CTL