sql-loader

Can variables be passed to a SQL*Loader control file?

Suppose you have a table: CREATE TABLE Customer ( batch_id NUMBER, customer_name VARCHAR2(20), customer_address VARCHAR2(100) ) And suppose you have a control file to populate this table: LOAD DATA INFILE 'customers.dat' REPLACE INTO TABLE Customer ( batch_id ??????, customer_name POSITION(001:020), ...