dbvisualizer: set max rows in a select query

Question

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 maxrows"

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.

Answer 1

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

Answer 2

Or you could just export directly to a file. This will allow to export many more rows than the DBVisualizer GUI can show you. When having to export a few million records (should you ever need that), this is quite useful.

Simply do something like this in your SQL Commander:

@export on; @export set Filename="d:\temp\export" format="CSV" DecimalNumberFormat="00000000000" CsvRowDelimiter="\r\n" CsvIncludeColumnHeader="false";  SELECT YOURFIELD FROM YOURTABLE WHERE SOMEFIELD = AFILTERVALUE; 

You can find more about this (and the various parameters) here: http://www.dbvis.com/products/dbvis/doc/7.1/doc/ug/sqlCommander/sqlCommander.html#mozTocId448386