Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Extracting a piece of a cursor

Extracting a piece of a cursor

From: Francesco M. <fmarchioniNIENTESPAM_at_libero.it>
Date: Tue, 04 Mar 2003 16:45:40 GMT
Message-ID: <UK49a.176847$ZE.5303458@twister2.libero.it> 





Hi all Oracle Users,


I need to write a Stored Procedure that extract
a "piece" of a large resultset. Let's say I want to retrieve
from record n. 1000 to record n. 1100 of a Table. What's the
best way (for performance and less impact on the db)
to do it in PL/SQL ?


Thanks


Francesco
Received on Tue Mar 04 2003 - 10:45:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US