Re: Comparison of whole records

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Jan 2002 19:09:11 +0100
Message-ID: <tdj05u8iq5hoeoddvsunifnks9bsfeoamn@4ax.com>

On Thu, 24 Jan 2002 17:36:22 +0100, "Patrick J." <patrickREMOVE.jTHIS_at_kneip.com> wrote:

>Hi,
>
>On an Oracle 8.1.7 database, I have created triggers that maintain an
>history of all changes in every tables. But some processes are issuing
>updates on several records without changing data in them, this resulting in
>unnecessary overloading of history tables.
>
>Is there a way in a trigger to compare :old and :new records, without
>comparing each field of the record?
>
>Thanks,
>
>Patrick J.
>

No

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 24 2002 - 12:09:11 CST