1. how to connect to the data base(oracle) using shell script
Look at this post

2. how to retrieve data from data base
Post

3. how to process the data retrieved from database (i.e result set)
Post

4. how to update the data base in turn.
Post

Use the search to look through previous postings. They could help.

Vino