Import text into Oracle using the control file

xiaoxiao2021-03-06  92

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

转载请注明原文地址:https://www.9cbs.com/read-123279.html

New Post(0)