I know I can change the fetch array size in preferences, but isn't there a way to continue fetching after the first n rows? There are times when I want to see a lot of rows but don't necessarily want to change the preference. I've been using PL/SQL Developer and it fills the window with however many rows will fit. There are then 2 buttons you can push, one to add on the next n rows, the other to add all rows. Isn't there a way to do this in SQL Developer's SQL Worksheet?
Do you want to fetch all the rows (if needed)? (Btw: Please post version and OS you are using while asking a question ). Try CTRL + PGDN when you are in the result window. It will fetch all rows.