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
Login to rate this answer.
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 )
Login to rate this answer.
Cursor advantages:
--> Using cursor to getting multiple values.
--> One cursor have multiple select statements
--> Cursor parameters
i.e cursor cursor_name (parameter datatype)
is
select * from table_name
where(condition)
-->Where Current of Clause: this is use full when the primary key is not present.
Cursor disadvantages:
-->It is returned by only one row at a time.
--> It gives less performance
-->Each time we fetch a row from the cursor, where as a normal cursor select statement query makes only one trip.
Login to rate this answer.