Toad output data grid only shows 500 Rows at a time

oracle toad
user4032346 picture user4032346 · Nov 13, 2014 · Viewed 14.7k times · Source

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 ?

Answer

Patrick Hofman picture Patrick Hofman · Nov 13, 2014

Well, that is considered a feature.

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

Related questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More
SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be …

Read More