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

Please refrain from cross-posting - a quick read through our simple rules would have enlightened you on this.

I have left your duplicate thread intact.

Thanks
ZB