SQL Developer Query Results Limited to 5000 Rows
Last updated on AUGUST 24, 2016
Applies to:Oracle SQL Developer - Version 4.1 and later
Information in this document applies to any platform.
SQL Developer 184.108.40.206
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms