Re: Mutating tables?

From: Gerrit-Jan Linker <gjlinker_at_litconsulting.freeserve.co.uk>
Date: Thu, 25 Mar 1999 17:41:36 -0000
Message-ID: <7dedhv$l5$2@news8.svr.pol.co.uk>

Hi,

Realise what happens if you are inserting/updating rows in a table and you are performing a query in the same time. The table is not in a definite state and the query therefore is not executable. The query result may depend on what your insert/update will change in the table.

To give this situation a name Oracle introduced the name: Mutating Table: a table in change.

You get into this situation with row level triggers on tables in which you access the same tables.

Read the manuals carefully and in any case experiment a lot! You'll figure it out.

Gerrit-Jan Linker
Developer of OraCodes, OraWeb, Oraxcel and OraSQL http://members.aol.com/gjlinker Received on Thu Mar 25 1999 - 11:41:36 CST