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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Row-Trigger question (Oracle 8)

Re: Row-Trigger question (Oracle 8)

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Nov 2004 08:01:52 -0800
Message-ID: <2687bb95.0411110801.1ba19040@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 -- Received on Thu Nov 11 2004 - 10:01:52 CST

Original text of this message

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