State the advatage and disadvantage of Cursor's?

Question Posted / swapna

2 Answers
8647 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

State the advatage and disadvantage of Cursor's?..

Answer / shilpa.oracle

Advantage:
Using cursors we can retrieve multiple records in a plsq block.

Disadvantage:
switching between the plsql statement executor and sql
statement executor at plsql runtime engine will consume time.

Is This Answer Correct ?

7 Yes

1 No

State the advatage and disadvantage of Cursor's?..

Answer / swapna

advantage :

In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.

disadvantage:

using implicit/explicit cursors are depended by Situation.
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.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer