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

Home -> Community -> Usenet -> c.d.o.server -> Re: mutating tables

Re: mutating tables

From: udaj <udaj_at_email.msn.com>
Date: Fri, 22 Oct 1999 10:59:15 -0400
Message-ID: <uSMhm3JH$GA.311@cpmsnbbsa02>


You can also create a view or temporary table so the database is selecting from one while updating the other.

Viji

Brian Howard <bkhoward_at_flash.net> wrote in message news:EF%O3.1255$pJ3.87605_at_news.flash.net...
> It seems like everytime I turn around, I'm running into the error that the
> table I am writing a trigger for might be mutating. On some of these I
can't
> figure out why. Is there any wisdom out there as to the best way to deal
> with this issue?
>
>
Received on Fri Oct 22 1999 - 09:59:15 CDT

Original text of this message

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