OraFAQ Forum: SQL & PL/SQL » What is Mutating Table?

Home » SQL & PL/SQL » SQL & PL/SQL » What is Mutating Table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is Mutating Table? [message #216780]

Tue, 30 January 2007 06:19

apps_ara
Messages: 29
Registered: January 2007
Location: Pune

Junior Member

Can anybody please tell me what is Mutating table and information regarding it.
thankyou
Leena

Report message to a moderator

Re: What is Mutating Table? [message #216788 is a reply to message #216780]

Tue, 30 January 2007 06:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is something like a rampage mutant ninja turtle, only smaller.

Report message to a moderator

Re: What is Mutating Table? [message #216790 is a reply to message #216780]

Tue, 30 January 2007 07:13

j0zele
Messages: 15
Registered: December 2006

Junior Member

Sorry about my english!!!

It happens when you are updating a table and you make a select in

For example

update LOL set LOL.lel =
(select LOL.lal from LOL where LOL.lel = 4)

as you can see im updating LOL and later (while LOL is updating) i make a select on LOL (who is updating), this is a mutating

you cant make select, update, delete, insert on a table that you are updating This is MUTATING

Smile

Report message to a moderator

Re: What is Mutating Table? [message #216797 is a reply to message #216790]

Tue, 30 January 2007 07:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Hmmm, I'd say that it isn't English that makes your explanation inaccurate. Here is an example of your code (translated to Scott's schema):

SQL> UPDATE DEPT d SET
  2    d.dname = (SELECT d1.loc FROM DEPT d1
  3               WHERE d1.dname = 'SALES'
  4              );

4 rows updated.

SQL>

Nothing mutates here. Except turtles.

Report message to a moderator

Re: What is Mutating Table? [message #216800 is a reply to message #216797]

Tue, 30 January 2007 07:50

Maaher
Messages: 7065
Registered: December 2001

Senior Member

link

MHE

Report message to a moderator

Previous Topic:	sql help
Next Topic:	READ FILE IN LOCAL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 01:02:22 CST 2024