Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implicit vs Explicit Cursor

AB312062Mar 10 2013 — edited Mar 12 2013
Hi

I read somewhere that Implicit Cursor is used when sql statement returns only one row and Explicit Cursor is used when sql statement returns more than one row.
I did not understand it. Why is it so? Can we not use Implict cursor when Sql returns multiple rows or explicit returns only one row?
can someone explain this with example.

Thanks
AB
This post has been answered by Billy Verreynne on Mar 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2013
Added on Mar 10 2013
#cursor
4 comments
1,112 views