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 && explicit Cursor example

447194Aug 6 2005 — edited Aug 7 2005

Hi,

Can u tell me what is the diff between implicit && explict cursor.

Since Implict cursor handelsif DML returns only one row and explict cursor handles if DML statement returns more than one row. I understood like this.
But if I do Update statement in Pl-sql statement it will update more than one row.
So, Can u give me the proper explanation and example plz

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2005

Added on Aug 6 2005

4 comments

1,132 views