These cursors cannot be named and, hence they cannot be controlled or referred from another place of the code. Whenever any DML operations occur in the database, an implicit cursor is created that holds the rows affected, in that particular operation. These cursors can also be named so that they can be referred from another place of the code. The set of rows the cursor holds is referred as active set. A cursor holds the rows returned by the SQL statement. PL/SQL allows the programmer to control the context area through the cursor. Oracle creates context area for processing an SQL statement which contains all information about the statement. A Cursor is a pointer to this context area.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |