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.
BY Best Interview Question ON 27 Jun 2020