Skip to Main Content
Forums

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

shell scripts to read data from a text file and to load it into a table

639485Apr 21 2009 — edited Apr 21 2009
Hi All,

I have a text file consisting of rows and columns as follows, 
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
My requirement is that, i should read the first 3 columns of this file using a shell script and then i have to insert the data into a table consisting of 3 rows in oracle .

the whole application is deployed in unix and that text file comes from mainframe. am working in the unix side of the application and i cant access the data directly from the mainframe. so am required to write a script which reads the data from text file which is placed in certain location and i have to load it to oracle database.

so I can't use SQL * loader.

Please help me something with this...

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2009
Added on Apr 21 2009
#generic-linux, #linux
5 comments
6,446 views