Create Shellscript

I am new to UNIX.
I got the file from Oracle, with
two columns (Table Name and Column Name). I need to create the shell script where the result suppose to include
plain text, <table_name>, <Column_name> from the file.
Plain text will be the statements to create index in Oracle.
something like that:
"create index on" <table name>.<column_name>

Thanks

A hack way of doing this is using sed or vi...

May not be what you are after but I have done similar with Sybase output from queries...

Just use a substiture command similar to this

:1,$ s/^/whatever in here/g (to put string at start of lines)
:1,$ s/$/whatever in here/g (to apend to end of lines)