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!

How to Display Number of Rows Deleted/Inserted etc... in PL/SQL

AAlsofyaniSep 9 2011 — edited Sep 9 2011

In Oracle 10g PL/SQL, I have a delete statement in a stored procedure. It is not in a cursor. I want to see the number of rows I've deleted. I can use the dbms_output.put_line package. I should know this, but I don't have time to perfect the syntax. How would I get the number of rows that get deleted and display it via dbms_output.put_lline?

This post has been answered by 513949 on Sep 9 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2011

Added on Sep 9 2011

3 comments

69,293 views