Cursors:
This lesson deals with working of Cursors and different kinds of Cursors. This lesson also provides an insight into the working of composite datatypes and their techniques or methods. This lesson also introduces Cursor Variables and their usage.
- Cursors
- Implicit Cursors
- Explicit Cursors
- Cursor Attributes
- Unconstrained Cursors and constrained Cursors
- Using Cursor for update
- Using Composite Datatypes
An Oracle uses workareas to execute SQL statements and store processing results. The PL/SQL construct known as Cursor permits a workarea to be named, to access and store its information. They are classically used in areas where the query inside the PL/SQL block retrieves more than one record. A cursor is a pointer to handle the circumstance area or the memory area or workarea. The result set of information is known as Result Set.