Link to home
Start Free TrialLog in
Avatar of Jim Horn
Jim HornFlag for United States of America

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
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Mac?

Try "Features".  Preferences was the last option on mine.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.