Is there a workaround for the 'mutating table' problem in a trigger ?

From: <coolcat_at_citynet.net>
Date: 1996/04/11
Message-ID: <4ki28r$1oi_at_news.citynet.net>#1/1


Hi

In a trigger on a table, I want to do a
SELECT MAX() ...
from that table and update a denormalized column in another table.

However, the table obviously mutates.

I understand SYBASE has a workaround using which you can do a SELECT on the table on which the trigger is defined.

Does ORACLE ?

TIA. Received on Thu Apr 11 1996 - 00:00:00 CEST

Original text of this message