Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Comparison of whole records

Comparison of whole records

From: Patrick J. <patrickREMOVE.jTHIS_at_kneip.com>
Date: Thu, 24 Jan 2002 17:36:22 +0100
Message-ID: <3c5037f8$1_2@news.vo.lu> 





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.
Received on Thu Jan 24 2002 - 10:36:22 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US