#Cursors plsql update

It is a user-defined cursor declared in the Declare section of PL/SQL block and is used in its Executable section. The cursor which has to be created, maintained and closed by a program through PL/SQL code for the execution of any SELECT query that returns more than one row is called Explicit Cursor. When a DML statement is executed an implicit cursor is created and attached to it. Implicit Cursors are controlled by Oracle and programmers cannot access its information.

#Cursors plsql update

The cursor which is automatically created, maintained and closed by the Oracle engine while execution of any DML(Data Manipulation Language) queries like INSERT, UPDATE or DELETE are called Implicit Cursor. Types of Cursor in PL/SQLД¬ursor can be divided into two types based on the condition under which they are created and used: This data is then transferred to the client machine via network.

And the cursor occupies memory size required to hold the number of rows in the active dataset.Д¬ursor containing the values retrieved from a table are opened in the predefined area of the main memory by oracle engine. When the oracle engine executes an SQL statements, the row of data returned is stored in cursor and is called active data set. Such a work area is privately used for SQL operations by the oracle engine. In this tutorial we will learn Cursor in PL/SQL which is nothing but a pointer to the work area or context area of oracle engine.ДЄ cursor is a pointer to the work area or context area, used by the oracle engine for executing SQL statements.