5

I am using Oracle 11g with Toad 12.5.1.1 and the output grid only shows me 500 rows at a time. Is there a way to make toad display all the results at a time or is there a way to find the number of rows returned even though the grid only shows 500 records ?

user4032346
  • 399
  • 1
  • 5
  • 11
  • 1
    What's the use of seeing more then 500 rows? If you want to export: Toad fetches all anyway, if you want to count: Why not just count (i.e. by select count(*)), if you want to see something special: select what you want to see. – evilive Nov 13 '14 at 22:15
  • This is late to the party, but probably this question would be a better fit for "SuperUser": https://superuser.com/ – JosephDoggie Mar 29 '23 at 13:17

3 Answers3

8

Well, that is considered a feature.

If you enter the grid and hit Ctrl+End it will fetch all rows for you.

Patrick Hofman
  • 153,850
  • 22
  • 249
  • 325
1

If that's what you want to do, you need to set the OCI Array Buffer Size not the Limit Grid Fecth.

See here for more details: http://www.toadworld.com/products/toad-for-oracle/f/10/t/8909.aspx

Mark J. Bobak
  • 13,720
  • 6
  • 39
  • 67
  • 1
    That option was removed in recent releases (12.5 won't have it) although it's been reintroduced in the current 12.7 beta. – Michael S. Nov 13 '14 at 22:33
  • 1
    Mark, In toad options>Oracle>General i dont see OCI buffer size option. There is a DBMS o/p> default buffer size but i think that disabled for me. – user4032346 Nov 13 '14 at 22:50
  • 1
    If the option was removed in 12.5, but will return in 12.7, I don't think you have much of an option, other than to wait for 12.7 to be released, or move to 12.7 beta.....if the option isn't in the release you're using, you're stuck. – Mark J. Bobak Nov 14 '14 at 15:59
1

Right click on the grid and use the option "Record count...". It will display on a floating windows the total record count.

Other option is to encapsulate your query in a SELECT count(*) FROM (your query).

Paco Abato
  • 3,920
  • 4
  • 31
  • 54