SQL Loader

[moepower]

On a weekly basis I'd get ten .cvs files from different sources (exact same data format). Is it possible to get SQL Loader to query the file names and process them without me having to specify the name one at a time? The file names change on a weekly basis eventhough the data format stays the same.

Thanks,

 

[carp]

No. However, you should be able to write a script that runs at your OS level that writes out the sql loader invocation file. If the output of this script was named consistently, then you could set up a chron job that runs the invocation file.