Hi everybody,

I have a problem while using oracle sqlldr in unix.
I get a .dat file through SFTP and placed at some location.I need to write a shell script to pick the .dat file dynamically what ever the full name so that i can refer this .dat file in my sqlldr control file.

eg:
abcd_sysdate_timestamp.dat is the file format.
abcd_20090524_193545.dat a sample example.I need a shell script to dynamically pick the file. The file doesent come periodically.It may come any time with that days date and time,so irrespective of the time,date and format my shell script has to pick this .dat file format and place it in sqlldr control file.So that control file can load it into the database.Please respond with any suggestions and answers.Awaiting!!!!!!!!!!!!!

Thanks