SQL Developer: how to visualize all rows returned by a query
To view the results of a query in Oracle SQL Developer, we have two possibilities:
- View as Grid (F9 key)
- Run the script (F5 key)
In the first case SQL Developer will fetch a number of lines, leaving you the ability to scroll down the sidebar and recovering, as you scroll down, the next lines. In the second case will make a fetch of a number of rows (500 by default) and the print output without possibility to see them all.
To see (or rather to do the fetch) all rows returned by the query that we launch, you must set the “Maximum number of rows to display in a script” to the desired value. To do this, select Preferences from the Tools menu:
From the window that will open, select Database -> Worksheet. From here you can set the property to the desired value.
Now by pressing F5 key the script will continue running until you reach the maximum number of rows specified by us.
