|
Define scrollable cursor.- You can use keyword SCROLL to make cursor Scrollable.
- It can scroll to any row and can access the same row in the result set multiple times.
- A non-scrollable cursor is also known as forward-only and each row can be fetched at most once.
- It is commonly used in modern screen-based applications in which the user scrolls back and forth through the data.
- It has the ability to detect the changes to resultset.
- If a scrollable cursor can detect changes to rows, then it can only detect them.
|
