Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit number of rows returned in Toad

395981Mar 4 2004 — edited Mar 4 2004

Hi,

I use toad to query a database, in fact, its a data warehouse and each time my query returns a huge number of rows and I have to wait for quite some time. Is there a way of getting only a few rows at a time. I mean, I want to see the complete data returned by in a piecemeal manner, say it fetches me the first 30 rows and I keep seeing this data while it keeps getting the next 30.

Any suggestions?

Thanks in advance,
Rajesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2004

Added on Mar 4 2004

#general-database-discussions

4 comments

8,143 views