InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are Scrollable Cursors? How Are They Created? |
|
Answer» The scrollable CURSORS are the ones that can get the ENTIRE SET of rows as single entity, within which all the rows present can be accessed in any order without the open/close of cursor DONE for every row access. The scrollable cursors are created with the keyword SCROLL added to the CREATE Cursor statements. The scrollable cursors are useful for the access of information from different rows but not for the delete/insert of new rows. The scrollable cursors are the ones that can get the entire set of rows as single entity, within which all the rows present can be accessed in any order without the open/close of cursor done for every row access. The scrollable cursors are created with the keyword SCROLL added to the CREATE Cursor statements. The scrollable cursors are useful for the access of information from different rows but not for the delete/insert of new rows. |
|