Total Pageviews

Thursday, September 13, 2012

Is Delete a cursor?

2 comments:

  1. Yes, DELETE and UPDATE as well as INSERT (DML) are implicit cursors and we can use cursor attributes with them.

    Example:

    DELETE shop;

    Here sql%rowcount will give the exact number of rows deleted.

    ReplyDelete