shell script to read data from text file and to load it into a table in TOAD

Shell Programming and Scripting
1

Hi....can you guys help me out in this script??

Below is a portion text file and it contains these:

GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005678 000001 000000 000000 000000 000000 000000 000001
I would like the first 3 columns of data to be read by the script to insert them into a table in Toad.
The table is IMSERNOS
and its contains 3 fields..namely:
ImiCode varchar2(6),
CustNo varchar2(9),
SerNo varchar2(9)

How to create a script(ksh) that reads the data and insert this data into the Toad?

Thanks in advance.

2

you may modify below script to address your issue

awk '{print "insert into tablename values("$1","$2","$3")"}' filename