WHAT ARE CURSORS IN PL/SQL ?
A cursor is a temporary area which is created in system memory at the time of program executed.Cursors contains information on Select statement and all the rows that are accessed by this statement.
This area is used for manipulate the data that is retrieved from the database and store it.This area (cursor) may hold more then one row but can process only one row at a time.
There are Two types of cursors in PL/SQL placeholders
- Implicit Cursors
- Explicit Cursors
Implicit Cursors
Implicit Cursors are created by default when DML statements like, SELECT, INSERT, UPDATE AND DELETE statements are executed.
Explicit Cursors
Implicit and Explicit Cursors both have same function but different in fetching data.Explicit Cursor is created at the time when Select statement is retrieved the more than one rows.this cursor is store the multiple records,only one record is processed at a time which is called a current row.
Good job
ReplyDeleteThanks
Delete