Skip to Main Content
Forums

Database 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!

skip last record while loading using external table

631510Dec 18 2009 — edited Dec 23 2009
Hi Gents,

I have a requirement to load data from text file to oracle database using external table. I need to remove the header and trailer records.

i can use skip option to remove the header ie first line.

Is there any possibility to remove the trailer record (ie last line) using external table.


Thanks in advance \

Fento
This post has been answered by 732412 on Dec 22 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2010
Added on Dec 18 2009
#database-key-features, #export-import-sql-loader-external-tables
10 comments
5,558 views