SQL Developer

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!

How can I stop my .csv file importing all the blank rows into a table?

User_SJ213Jan 6 2022 — edited Jan 6 2022

I have a .csv file ready to import using PL/SQL Developer.
It works other than it imports every single blank row also down to row 1048576.
Bizarrely when I ran a smaller subset of the data (about 10 rows) it just imported the 10 rows!
Any thoughts would be appreciated.

This post has been answered by thatJeffSmith-Oracle on Jan 6 2022

Jump to Answer

Added on Jan 6 2022

#pl-sql, #plsql, #sql-developer

2 comments

413 views

1 mention