CURSORS
From: Ravindr Dankanikote 703-913-2537 <dankanir_at_postoffice.manassas.ibm.com>
Date: 1995/10/20
Message-ID: <468h9t$ttt_at_news.manassas.ibm.com>#1/1
Date: 1995/10/20
Message-ID: <468h9t$ttt_at_news.manassas.ibm.com>#1/1
I have tables with a million rows at a time. I want to fetch 500 rows
at a time. Because I am constrained by both RAM and performance,
I cannot retreive everything to memory or bring it to some other
storage area.I need to be able to go back for a previous 500 rows at any
given time. Is this possible?
We use Stored Procedures to access everything in our database.
Can I declare a pl_sql table and select my results into that ?
Any other ideas?
Thanks
Ravi
dankanir_at_lfs.loral.com
-- Ravindr Dankanikote 703-913-2537Received on Fri Oct 20 1995 - 00:00:00 CET