1.

Why do we need cursor in PL SQL?

Answer»

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.


Discussion

No Comment Found

Related InterviewSolutions