oracle Toad 输出数据网格一次仅显示 500 行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26918748/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Toad output data grid only shows 500 Rows at a time
提问by user4032346
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 ?
我将 Oracle 11g 与 Toad 12.5.1.1 一起使用，输出网格一次只显示 500 行。有没有办法让蟾蜍一次显示所有结果，或者有没有办法找到返回的行数，即使网格只显示 500 条记录？
回答by Patrick Hofman
Well, that is considered a feature.
嗯，这被认为是一个功能。
If you enter the grid and hit Ctrl+Endit will fetch all rows for you.
如果您输入网格并点击Ctrl+End它，它将为您获取所有行。
回答by Mark J. Bobak
If that's what you want to do, you need to set the OCI Array Buffer Sizenot the Limit Grid Fecth.
如果这就是你想要做的，你需要设置OCI Array Buffer Sizenot the Limit Grid Fecth。
See here for more details: http://www.toadworld.com/products/toad-for-oracle/f/10/t/8909.aspx
有关更多详细信息，请参见此处：http: //www.toadworld.com/products/toad-for-oracle/f/10/t/8909.aspx
