Cursor in sql pdf


Your contribution will go a long way in helping us serve more readers. A cursor is a pointer to this context area. SQL controls the cursor in sql pdf area through a cursor.

The set of rows the cursor holds is referred to as the active set. You can name a cursor so that it could be referred to in a program to fetch and process the rows returned by the SQL statement, one at a time. Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, when there is no explicit cursor for the statement.