explicit cursor


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

Green Venn Diagram

METAMIA is a free database of analogy and metaphor. Anyone can contribute or search. The subject matter can be anything. Science is popular, but poetry is encouraged. The goal is to integrate our fluid muses with the stark literalism of a relational database. Metamia is like a girdle for your muses, a cognitive girdle.