1. Import the data into the Excel table, organize data, make it distributed in terms.
2. Save the Excel data as a comma separated format of CSV.
3, establish the .ctl file, the file content includes the path of the CSV file, and the table name, separation method, and table of the table.
E.g:
Load Data Infile 'E: /DK_INFO.CSV' Append Into Table DK_INFO_TMP FIELDS TERMINATED BY ',' (VIP_CODE, Comm_Req, Remark)
4. Execute the sqlfr command in the command line mode, of course, provided at least Oracle clients.
For example: SQLLDR
Userid = CSSS / CSSS @ ibss control = d: /dk_info.ctl log = d: /dk_info.log
