Load the data file name in the column of table using sqlloader
I have set of files in a folder, all the data present in these files should be loaded in the oracle database through sql loader. The no of files present in that folder may change day by day. I have two problems.
1. All the files should be loaded into the database without specifying the file name in the control file. (dynamically the filename should change).
2. The data file name should be loaded in the column of the table along with the data.
Kindly give me any suggestions for this. Prefarably any unix shell script.