Why do we need cursor in PL SQL?
In PL/SQL a cursor is needed for the following reasons:
- To retrieve data, a single row at a time, from a data set, unlike in the SQL commands where all the rows are operated on the result set at one time.
- Cursors are also used for updating records in a singleton fashion or a row by row manner into a database table.
Suggest An Answer
No suggestions Available!