Get two records from PLSQL cursor

Posted by Hany on Stack Overflow See other posts from Stack Overflow or by Hany
Published on 2010-05-14T17:31:22Z Indexed on 2010/05/14 17:44 UTC
Read the original article Hit count: 560

Filed under:

My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming it's a simple operation; you can do it with a for index by increasing it by 1.

Do you have any suggestions?

© Stack Overflow or respective owner

Related posts about plsql