State the advantage and disadvantage of Cursor?

Advantage : In pl/sql if you want perform some actions more than one records you should user these cursors only. bye using these cursors you process the query records. you can easily move the records and you can exit fromprocedure when you required by using cursor attributes. disadvantage: using implicit/explicit cursors are depended by sutiation. if the result set is les than 50 or 100 records it is better to go for implicit cursors. if the result set is large then you should use exlicit cursors. other wise it will put burdon on cpu. Disadvantage: Each time we fetch a row from the cursor, it result a network round trip, where as a normal selectstatement query make only one round trip.