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

Question

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 ?

Michael Ballent · Accepted Answer · 2012-09-11 22:52:49Z

12

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)

answered Sep 11, 2012 at 22:52

Michael Ballent

1,0889 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

sky scraper Over a year ago

Wow ! What just happened ? CTRL + END solves the problem but mouse scroll does not. Looks like a bug to me.

Michael Ballent Over a year ago

Could be a bug... I am using 3.0.04

Michael Ballent Over a year ago

Silly question what happens when you re-drag your shrunken scroll bar, do you get more rows?

sky scraper Over a year ago

I am not sure what that means. After ctrl+end, i see all rows. I can also move my scroll bar normally. But, if i press the refresh button and move the bar, same problem occurs.

barneymc Over a year ago

Really helpful, 500 LIMIT was a bugbear of mine, didn't realize you could get all the records so easily...

|

Collectives™ on Stack Overflow

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

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related