ORACLE -- SQL Developer, return all rows

How can I get "Oracle SQL Developer"
to return all rows when clicking
the "Data" TAB on a table ?
Current Steps:
 1. click "Data" TAB
 2. wait a few seconds
 3. scroll down on "resultset"
    several times until all
    500+ rows display

I could see "Row# __ of __"
in TOAD, but "Oracle SQL Developer"
does not seem to have this option.
Who is Participating?
gatorvipConnect With a Mentor Commented:
You can change that from

Tools / Preferences / Database / Advanced / SQL Array Fetch Size

although I wouldn't recommend doing this if you're retrieving more than a couple thousand records.
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
i click once into the results, and then use <ctrl><a> to make sql developer to fetch all records
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.