Posted by Alex Kuznetsov on 07/21/07 18:20

On Jul 21, 11:51 am, DA Morgan <damor...@psoug.org> wrote:
> Serge Rielau wrote:
> > To the best of my knowledge there is no such thing as OLD TABLE/INSERTED
> > and NEW TABLE/DELETED in Oracle, hence there are no statement triggers
> > in Oracle which actually can operate on the data set.
> > And that was Alex's point.
>
> No it wasn't: That is your point and if you wish to make it move it to
> c.d.o.s. Sorry folks.
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Actually Serge got it right, that was exactly my point. To my best
knowledge one year ago, in10G, Oracle's triggers could not access the
whole set of modified rows. Nor the body of the trigger would fire if
no rows were modified at all. This does not qualify as a statement
level trigger. Pls correct me if I am wrong.

Cheers,
Alex Kuznetsov, SQL Server MVP
http://sqlserver-tips.blogspot.com/

• Next in forum: Oportunidade Stefanini It Solutions
• Prev in forum: Re: Trigger After Delete - I need a Trigger Before Delete
• Thread view: Re: Trigger After Delete - I need a Trigger Before Delete

[Reply to this message]