Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm running a simple query on an Oracle database table like

select * from tableA

and DBVisualizer cuts the query short at 1000 rows. How do I remove this limit? Message is "number of rows limited by maxrows".

share|improve this question

Max rows is specified just above the SQL Commander tab in the second field from the right. On the Object View tab it is at the bottom left of the results window. For a single table query I generally use the Object View window. It is easy to setup filters in the Data sub-tab.

Setting this value too high will result in a crash when you run out of memory.

Is there a reason you want more than 1000 records returned? That's a lot of data to scroll through.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.