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!

Advantage of Explicite over implicite cursor

rahulrasOct 12 2003 — edited Oct 13 2003

Hi all,

Just a question about the implicit and explicit cursors.
Its recommended in many books and documents that in PL/SQL one should use explicit cursors, ALWAYS, even if you know that the cursor will be returning( or will be used to return ) only one row.
What is the exact difference that will make ?
Please guide.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2003

Added on Oct 12 2003

2 comments

348 views