Jim Horn
asked on
Oracle SQL Developer: How to turn off automatic rowcount limits?
Hi All
Oracle SQL Developer v4.1.2.20, every time I run a query the return set is limited to 50 rows.
Where's the setting to turn this off / edit this number?
Thanks in advance
Jim
Oracle SQL Developer v4.1.2.20, every time I run a query the return set is limited to 50 rows.
Where's the setting to turn this off / edit this number?
Thanks in advance
Jim
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can select a row in the results window and press ctrl+down to retrieve all records. I don't think there is a setting to get all records at once as sql developer uses a buffer to get a part of your results. The F5 or run as script is like the sqlplus spool command.
Try "Features". Preferences was the last option on mine.