Screen-Shot-2016-01-04-at-11.49.53-A.png

<div>
Mac?<br />
<br />
Try &quot;Features&quot;. &nbsp;Preferences was the last option on mine.
</div>


Screen-Shot-2016-01-04-at-11.56.51-A.png

<div>
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.
</div>


<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
Oracle SQL Developer v4.1.2.20, every time I run a query the return set is limited to 50 rows. <br />
Where's the setting to turn this off / edit this number? <br />
<br />
Thanks in advance<br />
Jim
</div>
</div>


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: How to turn off automatic rowcount limits?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.