Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!not-for-mail
From: Mark.Powell@eds.com (Mark D Powell)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Row-Trigger question (Oracle 8)
Date: 11 Nov 2004 08:01:52 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <2687bb95.0411110801.1ba19040@posting.google.com>
References: <987ebcdd.0411110035.2ee89cc6@posting.google.com>
NNTP-Posting-Host: 192.85.50.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1100188913 27864 127.0.0.1 (11 Nov 2004 16:01:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 11 Nov 2004 16:01:53 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:114167

m.kreitmann@gmx.net (Michael Kreitmann) wrote in message news:<987ebcdd.0411110035.2ee89cc6@posting.google.com>...
> Hello,
> 
> I've a question about row triggers under oracle.
> If I define the trigger "FOR EACH ROW", the trigger will be fired n-times
> if the firing statement will hit n records. Is there any unique ID or hash-code
> or anything else, that is equal for all of these n executions of this trigger
> (and only for these n executions ? - the next statement firing the trigger 
> must produce a new (unique) ID ...)
> Many thanks for your advice!
> 
> Regards
> Michael

What is it you are trying to do?
What version of Oracle will you be using?
Will the rows you wish to associate be submitted as one transaction or many?

HTH -- Mark D Powell --