SQL Developer Query Results Limited to 5000 Rows (Doc ID 2175009.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle SQL Developer - Version 4.1 and later
Information in this document applies to any platform.

Symptoms

Environment
SQL Developer 4.1.0.17
Database 11.2.0.4.0
Windows 8.1 64-bit

Problem
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:

spool c:\Out.csv;
Select /*csv*/ * from dba_objects;


Results
Only 5,000 rows currently supported in a script results.
5,000 rows selected.

Changes

 Upgraded from SQL Developer 3.2 which did not have the issue.

Cause

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