Skip to Main Content
Forums

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!

Problem with Blank lines in external tables???

421036Sep 8 2004 — edited Sep 8 2004
All days I receive files with 2 blank lines in the end of the file.
I have external tables to read its.

For example I have the file Customer with 100 customers but If I put:

select count(*) from et_customer

It returns 101!!!!!!

Could the external tables not read the blank line??? How can I do it????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2004
Added on Sep 8 2004
6 comments
552 views