Can a SQL* Loader CTL file accept parameter input?
Posted on 2004-07-06
A co-worker of mine asked this question, and I've researched this, and I'm pretty sure (99%) that this is not possible. But maybe someone has figured out a way to do it? They want to be able to change the CONSTANT value assigned to a column during the loading phase. The other way to do it would be to load the data into the table with that column being set to NULL, then calling a SQL* Plus script and doing an UPDATE on that column for the whole table.