Re: Row-Trigger question (Oracle 8)

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0411110801.1ba19040_at_posting.google.com>...
> m.kreitmann_at_gmx.net (Michael Kreitmann) wrote in message news:<987ebcdd.0411110035.2ee89cc6_at_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 --

Hi!

I'm using Oracle 8.1.7 und 9.2.0
What I want to do:
Inside my trigger I want to write one row for each update statement
into table1 and n rows for each updated record into table2. This to
table must be joined over an unique key, so that I want to use one
trigger for writing both tables.
Any yes, this will be (of course) one transaction.