Shell Script: want to insert values in database when update script runs
 

Hi ,

I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder like: tmp/MyFile into "MyTable"(database).
I don't have any idea about how to read data from file and insert that data into database table. This is for description and log field. Datatype of these fields is CLOB. Even I want to find max(id) from exiting table data, so that I can insert mew entry as maxid+1.

I am facing problems while writing this script.
Could anybody help me with this?

Thanks in advance
Ring

Which database are you using, how do you interface with it from the
command-line?


Cheers,
Tink

I am using oracle database.
used commands are like this :
VALUE=`sqlplus -silent ypsystem/yp <<END
set pagesize 0 feedback off verify off heading off echo off
select max(id) from releasenotes;
exit;
END`