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
plsql
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