Script to upload data into oracle database from flat file using Sql Loader

OPTIONS (SKIP = 1)  # optional if you want to skip the first line of your file
LOAD DATA
INFILE '/path where you placed yor flat file on server/'
APPEND INTO TABLE table_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(Column1,
colmn2
enter the columns your required for your file
)


save file (.ctl) and always place to the bin folder ex: CUSTOM_TOP/BIN
REGISTER A CONCURRENT PROGRAM FOR THE SCRIPT AND SELECT EXECUTION METHOD AS "Sql Loader"
AND RUN THE PROGRAM FROM srs WINDOW