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.
Useful?
Writer: kz4ora
LCC:
Where:
Date: Aug 3 2010 9:18 AM
No critique for this page.
Feel free to be the first
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