PLSQL CURSOR
CURSOR à In order to process SQL statements oracle will allocate an area of memory known as context area. PL/SQL uses it to store and execute SQL statements. The information retrieved from database which is available in context area is known as active set. A CURSOR is pointer which works on active set. CURSOR points one row at a time in context area. A CURSOR is used to process multiple rows using PL/SQL. à It is a private memory or buffer. It is used to hold the data from tables or views in memory location for manipulation purpose. It is valid in PL/SQL block only. à CURSORs are variables that you can define in the declaration section. à Types of CURSORs 1.Implicit Cursor 2.Explicit Cursor à 1.Implicit Cursor It is cursor that is automatically declared by oracle every time SQL statement is executed. They are identified by “SQL % <CURSOR ATTRIBUTES>”. When the executable part of the block is issued SQL statement, PL/SQL creates an implicit cursor. ...
Please Provide SQL document..
ReplyDelete