Explicit Cursor

a: Explicit cursor ~
b: a temporary area

What: "Cursor is like a temporary area where you can process fetch the records and process then individually as required" The intent of this data structure is to select a subset of a table and put it into a separate memory area. This subset of the main table can then be processed by pl/sql 1 row at a time. The net benefit is improved performance, since a whole table does not need to be analyzed one row at a time.

Writer: kz4ora
Date: Aug 3 2010 9:18 AM

No critique for this page.
Feel free to be the first

Please review the linked page for context.
If you can think of something better than this,
please add it to the database

(email or url) optional

This is an anti-spam device. Are you Human?

If so, please click the circle next to 'Yes' to submit your comment