Re: PL/SQL update record counts

vopipari_at_ehealthcontracts.com (Vince) wrote in message news:<8d71f979.0111091658.32815990_at_posting.google.com>...
> Is there a simple way of getting the count of records updated via an
> update statement? Is there a SQL Message that can be used? I would
> prefer to not have to first select the count of the records to be
> affected, then issue the update. Also would prefer not to create a
> on-update trigger, as it is not necessary to have execute under normal
> conditions.
>
> Thanks

please use SQL%ROWCOUNT for this purpose _directly_ following the update.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Sat Nov 10 2001 - 19:48:33 CET