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
# 550 Critique Analogy