Re: How do I find out how many rows where effected by an update?

In our last gripping episode "Kevin Hunt" <khhis_at_triplecrownsvc.com> wrote:
> How do I find out after an UPDATE command, how many rows where
 effected?
>
>

Through SQL*Plus the count of affected rows is displayed after the update is completed. With PL/SQL one can use %ROWCOUNT as long as the cursor has not been closed. One may also create a counter in PL/SQL and increment it for each row updated.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/