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

pallavishetty · #1 (**permalink**) 10-31-2008

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.

summer_cherry · #2 (**permalink**) 10-31-2008

you may modify below script to address your issue

Code:

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Perl script to load text file into DB field	aristegui	Shell Programming and Scripting	2	09-15-2008 03:55 AM
Need Shell Script to upload data from Text file to Oracle database	chandrashekharj	Shell Programming and Scripting	6	03-26-2007 03:21 AM
help for writing shell script to export table data	sankarg	Shell Programming and Scripting	3	10-18-2006 06:01 AM
Howto read data into a shell script	banjo	Shell Programming and Scripting	4	09-06-2006 06:41 AM
Shell Script to Load data into the database using a .csv file and .ctl file	Csmani	Shell Programming and Scripting	3	05-24-2006 08:09 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by