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!

How to increase the number of rows fetched by default by Oracle

816802Dec 30 2010 — edited Dec 30 2010

Hi All,

I want to know is there any way where we can fetch the amount of records oracle fetches by default each time.

By default I can see whenever I execute a query, oracle is providing 500 rows for each fetch. (Any way to change it?).

Appreciate your inputs here.

Thanks & Regards,
MK.

This post has been answered by Nicolas Gasparotto on Dec 30 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2011

Added on Dec 30 2010

#general-database-discussions

6 comments

2,515 views