How to get all rows in my results, not just 100 rows?

Question

I am using the version of Microsoft Visual Studio 2012 Shell (Integrated).

When I right-click on any table and select "Query Window", I can write code to return values ​​from an Oracle database. But when I run it, I get only 100 rows of results .

How to get all rows of results ? Is there an option that I can check or remove to achieve this?

Answer 1

I do not use Visual Studio, but I suppose you just need to click the PgDown or End button in the result table. Where PgDown is a selection of the next 100 lines. The end is a selection of all rows. At a minimum, SQL Navigator is running.