From: "Simon Irvin" <sirvin@synomics.com>
Newsgroups: comp.databases.oracle.server
Subject: Which column is being updated
Date: Wed, 18 Apr 2001 12:00:37 +0100
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: connectit.synomics.com
Message-ID: <3add7410_1@nnrp1.news.uk.psi.net>
X-Trace: 18 Apr 2001 12:01:36 GMT, connectit.synomics.com


Is there any way I can make use of whatever information Oracle uses to
decide whether or not to fire a trigger that is only invoked on updates to a
subset of the columns in a table. (Hope that makes sense!)  What I suppose I
mean is when you define a trigger to be fired on "UPDATE OF column1" how
does Oracle know it is column1 that has been updated and can I obtain the
same information?

Cheers

Simon Irvin