Shell Programming and Scripting

Hi,

I have 5 files in a directory.

emp1_usage.txt
emp2_usage.txt
emp3_usage.txt
emp4_usage.txt
emp5_usage.txt

I am using sqlldr to get the contents of the above 5 files and store it in a temp table and update my original table using temp table.

for f in *emp*.txt
do
sqlldr usr/passwd control=data.ctl data=$f
done


Now, the problem i got is:

I have a table called 'emdc' in which one column has the values:

emp_name
------------
emp1
emp2
emp3

I should dynamically check what are the values in the emdc table and pass to the sqlldr those file-names which have the values in the emdc table.

Let me explain Clearly:

I should now process only emp1_usage.txt, emp2_usage.txt, emp3_usage.txt into the sqlloader.

The script should automatically check for the values in emdc table and process only the 3 files among the 5 files present in the directory.

Please send me the snippet of the code.

Thanks in advance...........