| Re: How do i breakup a TXT file and save it as multiple records????? [message #370291] |
Wed, 04 August 1999 11:07  |
Chris Hunt
Messages: 27
Registered: March 1999
|
Junior Member |
|
|
Hmmmm... difficult to say without seeing the file in question, but my guess is that you'll be better off using Perl or awk to massage the inbox file into a format friendly to SQL*Loader (or whatever the Oracle8 equivalent is).
The alternative is to read the file in however you can (SQL*Loader, UTL_FILE, whatever) into a temporary table of long VARCHAR2 fields, then write some PL/SQL to extract this how you want it.
I suppose it depends what skills you have/want to learn.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
