Inserting Values From A File Into A Table

Shell Programming and Scripting
1

Guys,

I want to insert some values from a log file into a temporary table. the values in the log file looks like this

SV_NAME  CC_NAME              CP_DISP_RUN_STATE  
-------  -------------------  -----------------  
sble01   ALLTEL WorkMon24Hrs  Running

I want to enter the values under SV_NAME, CC_NAME, CP_DISP_RUN_STATE
into a temporary table. the table has similar columns SV_NAME, NAME, Status.

Please help me guys. thanks in advance

2

We need to know what database - and I assume it means from a shell script

3

the database is oracle 9i

yes, i want to use shell scripts.

thanks