Dear friends,

I am trying to prepare a shell script which do the following task. Being a beginner in scripting I need a bit of help from you all for shell script which does the following job.

1.Check for existence of a file in a shared directory (at some remote location ) once in a day
2.Load the records from the file to the correct table via SQL Loader
3.Invoke SQL Plus via command line to run some update queries that are required before running the Server Task
4. And finally, run the Server Task via command line.

I don't have much knowledge of comparision functions , how to invoke cmd line and run sqlldr cmd for getting records in a table. Hope someone help me out.

Thnx