Hi,

I am using sqlloader to load files in oracle database. The sqlloader is being called by a shell script and uses xargs{} to load multiple files. THe files being loaded have date appended at the end of the name e.g. myfile030609. I would like to use the date at the end of the file to fill a certain field in my table.

Is there a way I can get the date part of the filename and DECODE this in the ctl (control file)? Thank you.