【How-to】How do i increase row limit in sql developer

You can use the Import Wizard to customize your preferences for the import environment and import data using the different methods like Insert, Insert Script, External Table, Staging External Table and SQL*Loader. … Set the Import Row Limit to 100 to be able to view 100 rows at a time.