Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Developer - cannot see some of the rows at the end?

I know that I have about 180 rows in my table. But, SQL developer lets me scroll down and see only 100. The scroll tab/field shows that there are more than 100. But, when i pull the scroll bar down, i don't see the remaining rows. After that, when i release the mouse button, the scroll bar returns to the middle of the scroll field.

This never happened before. Could it be a bug ?

like image 647
sky scraper Avatar asked Dec 15 '22 19:12

sky scraper


1 Answers

Click on any field of the rows that were returned, then hit CTRL+END to retrieve the reset of the rows... that is how I have always done it.

EDIT: could also be your preferences Tools -> Preferences Expand Database click on Advanced update the SQL Array Fetch Value (MAX = 500)

like image 71
Michael Ballent Avatar answered Dec 28 '22 08:12

Michael Ballent