Re: Row-Trigger question (Oracle 8)

Michael Kreitmann wrote:

> 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

I do not understand your question so I'm just going to guess.

If your trigger contains sequence_name.NEXTVAL ... each firing of the trigger will retrieve a new number from the sequence.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)