Skip to Main Content

SQL & PL/SQL

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!

Convert Long raw file into text format

6688Jan 20 2004 — edited Jan 21 2004
Hi,
I have a table with long raw column and I know there is a file saves in text format, how I convert this long raw file to text format.
Text file contain following data mention bellow (approx 25000 records at a time). I want to insert name related information in (table a) and employment related information in table b).
Name (45 char) address (100 car) phone (10 char) employment information (100)
Name (45 char) address (100 car) phone (10 char) employment information (100)
Name (45 char) address (100 car) phone (10 char) employment information (100)
Name (45 char) address (100 car) phone (10 char) employment information (100)

any help will be appriciated.

Noman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2004
Added on Jan 20 2004
2 comments
830 views