SQL Developer Query Results Limited to 5000 Rows
(Doc ID 2175009.1)
Last updated on NOVEMBER 12, 2019
Applies to:Oracle SQL Developer - Version 4.1 and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
SQL Developer 22.214.171.124
Windows 8.1 64-bit
When running a SQL script using Run Script option, SQL Developer query results is limited to 5,000 rows.
Sample script that reproduced the issue:
Select /*csv*/ * from dba_objects;
Only 5,000 rows currently supported in a script results.
5,000 rows selected.
Upgraded from SQL Developer 3.2 which did not have the issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document