Cursor Advantages and Disadvantages

Disadvantages:

Using implicit/explicit cursors are depended by Situation.

If the result set is less than 50 or 100 records it is better to go for implicit cursors. if the result set is large then you should use explicit cursors. other wise it will put burden on CPU

ad:using of cursor ,plsql program can control the context area as sql query result being process
disad:using of cursors we connot go backword (i.e i cannot go to frist record ofter plsql fetch five records form cursor  )

Cursor advantages: