This content has been marked as final. Show 3 replies
[url http://www.oracle-base.com/articles/10g/load-lob-data-using-sql-loader.php] Loading LOB Data using SQL * Loader1 person found this helpful
I would like to get the INFILE used in control file to be loaded as a column in the target table to be loaded ? Is it possible to do it in SQL Loader?
No - there is no way to reference the value that was specified as INFILE. Even if you could it would get loaded into every row.
I have the requirement to load the file name of data file(csv) as a column in my staging table.
How to achieve this using control file?
Plz reply asap.