Skip to Main Content
Forums

Oracle Database Discussions

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!

Sql loader into multiple tables with comma delimited files

90360Apr 11 2008 — edited Apr 14 2008
We are attempting to load file contents into different tables with a comma delimited file. File is like:

HEADR,BBBB,TRC,G,SCA,SHI,20080403
FILE1,PN041,20080402,0138516
FILE1,FF,20080402,024
FILE2,DDDD,ACCPT

The table to be populated is dependent upon the first 5 characters. I am aware that the POSITION parameter needs to be used to reset the pointer on each row, however the format is not fixed and will vary ( as per the FILE1 rows ). In this instance how do we reset the pointer to point to the beginning of the new row?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2008
Added on Apr 11 2008
#general-database-discussions
6 comments
5,376 views