Give which cursor is better for better performance means type of cursors?

Give which cursor is better for better performance means
type of cursors?

Question Posted / swapna

2 Answers
6674 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Give which cursor is better for better performance means type of cursors?..

Answer / swapna

If you deal with better performance You have to refer REF
CURSOR and its more advantage and effecient of Execution.

Is This Answer Correct ?

3 Yes

0 No

Give which cursor is better for better performance means type of cursors?..

Answer / rahul koshti

Definitely...Implicit cursors =>
Because From Release PL/SQL 2.3 ( Oracle 7.3 and earlier)
and above , Implicit cursors has been optimized therefore it
runs faster than the Explicit cursor.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer