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

Home -> Community -> Mailing Lists -> Oracle-L -> Cursors and result sets

Cursors and result sets

From: Linda Hagedorn <Linda_at_pets.com>
Date: Fri, 21 Jul 2000 13:59:39 -0700
Message-Id: <10565.112689@fatcity.com>


Hello,

Do cursors read rows directly from the database (thus including any rows which were inserted into the table after the cursor was first opened), or do they create a list of rowid's and retrieve the rows one by one (thus skipping any rows which were inserted into the table after the rowid result set was created)?

Any referral to doc is appreciated.

Thanks,

Linda Hagedorn Received on Fri Jul 21 2000 - 15:59:39 CDT

Original text of this message

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