SQL Developer Query Results Limited to 5000 Rows
(Doc ID 2175009.1)
Last updated on FEBRUARY 27, 2025
Applies to:
Oracle SQL Developer - Version 4.1 and laterOracle 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;
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 |