Return
-
Title
How can one change the number of rows displayed by default in Schema Browser? -
Description
When viewing Tables in the Schema Browser, 500 rows are retrieved in the Data tab, for most Tables, if one wants to see beyond that, scrolling helps.
However, if the Table has a column with a CLOB datatype, only 50 rows are displayed.
Where can one change this to 500?
-
Resolution
Go to Toad's top menu, View | Toad Options ... | Oracle | General | OCI Array Buffer Size, and set it to "Manual" and increase it as needed. -
Additional Information
NOTE: for older Toads, KB 21378 offers "Go to View | Options | Schema Browser | Data and grids | limit grid fetch".