My Oracle Support Banner

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.

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

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.