What are mutating tables?

When a table is in state of transition it is said to be mutating. eg :: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select.

Interview Candidate
Sep 12th, 2007
9
4229

PL/SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 9 of 9 Answers

sunil

Oct 8th, 2007

Mutating tables are the tables which is currently modifying by itself.

amahanit
Profile Answers by amahanit Questions by amahanit

Oct 13th, 2007

it's a table which is currently being modified by a trigger statement.

krishnaindia2007
Profile Answers by krishnaindia2007

May 3rd, 2008

Mutate means chage. Mutating table is a table that is being modified by update, delete or insert statement.