PL/SQL update record counts
From: Vince <vopipari_at_ehealthcontracts.com>
Date: 9 Nov 2001 16:58:17 -0800
Message-ID: <8d71f979.0111091658.32815990_at_posting.google.com>
Date: 9 Nov 2001 16:58:17 -0800
Message-ID: <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