There’s no setting to fetch all records. You wouldn’t like SQL Developer to fetch for minutes on big tables anyway. If, for 1 specific table, you want to fetch all records, you can do Control-End in the results pane to go to the last record.

How do I get all rows in SQL Developer?

There’s no setting to fetch all records. You wouldn’t like SQL Developer to fetch for minutes on big tables anyway. If, for 1 specific table, you want to fetch all records, you can do Control-End in the results pane to go to the last record.

How do I limit the number of rows in SQL Developer?

select * from ( select * from employees order by salary desc ) where ROWNUM <= 10; If you want to limit the result in between range, for example you want to sort the resultset by salary and limit rows from 10 to 20 in the resultset.