I have a control file test.ctl like this:
INSERT NTO TABLE TEST
FIELDS TERMINATED BY '|'
and I load the data by
sqloader control = test.ctl data=test.data ...
I have to keep changing the value for COL3 based on the requirements, so I would like to pass this value from outside instead of always modifying the control file. Is that possible?