Alex Rivera | Logout

DBVisualizer: set max rows in a select query

Asked 2011-12-07T16:46:24.150
33

I am using DBVisualizer 8.0.6 and when I run a simply query like

SELECT * FROM table;

It only shows the first 1000 rows and then stops the query and displays in the bottom left corner.

Number of rows limited by Max Rows setting

How do I change this?


I'm writing a query which needs to export a little over 1000 rows, but DBVisualizer has this set limit.

I tried something like:

  • @set maxrows 2000
  • then commit
  • then run my query

Still returns only 1000 rows. This is for an Oracle table.

Edit
Report

1 Answer

68

There is a box in SQL Commander labeled Max Rows. Set it to -1 for the complete result set.

Max Rows

answered 2011-12-11T21:16:43.827

Your Answer