OraTechSupportGroup : Message: Retrieve large amount of data

OraTechSupportGroup · Oracle Techniques Discussion Group

Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Retrieve large amount of data

Message #411 of 457 |

Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage.

Thank you

Ernie

Wed Mar 3, 2004 10:35 pm

Martinez Ernesto <ernesto33es@...>

Offline

Message #411 of 457 |

Expand Messages	Author	Sort by Date
Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage. Thank you Ernie ... Do...	Martinez Ernesto ernesto33es	Mar 4, 2004 2:36 pm
Ernie, Using pl/sql bulk feature you can retrieve number of rows together. Let me know if you need more detail, or go to metalink.oracle.com. Rajesh Arora ... ...	Rajesh Arora arora_rajesh@...	Mar 4, 2004 11:41 pm