Re: Mutating table and triggers

From: Dag Arne Matre <dam_at_robin.no>
Date: Fri, 19 Mar 1999 07:06:06 +0100
Message-ID: <7cspil$22r$1@troll.powertech.no>

This is what I'm looking for. But if my memory serves me right, you must specify that this is guaranteed, Oracle will not assume this. But where/how to tell Oracle this?

D A

Jonathan Lewis skrev i meldingen
<921795502.10387.3.nnrp-09.9e984b29_at_news.demon.co.uk>...
>There is one special case where the the mutating table does
>not occur, however. I can't remember the exact details at the
>moment, but it has something to do with the triggering statement
>guaranteeing (logically) to effect only one row of the table e.g.
> update where primary key = const
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Received on Fri Mar 19 1999 - 00:06:06 CST