Home » SQL & PL/SQL » SQL & PL/SQL » What is Mutating Table?
What is Mutating Table? [message #216780] Tue, 30 January 2007 06:19 Go to next message
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
Re: What is Mutating Table? [message #216788 is a reply to message #216780] Tue, 30 January 2007 06:58 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is something like a rampage mutant ninja turtle, only smaller.
Re: What is Mutating Table? [message #216790 is a reply to message #216780] Tue, 30 January 2007 07:13 Go to previous messageGo to next message
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
Re: What is Mutating Table? [message #216797 is a reply to message #216790] Tue, 30 January 2007 07:41 Go to previous messageGo to next message
Littlefoot
Messages: 20896
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.
Re: What is Mutating Table? [message #216800 is a reply to message #216797] Tue, 30 January 2007 07:50 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
link

MHE
Previous Topic: sql help
Next Topic: READ FILE IN LOCAL
Goto Forum:
  


Current Time: Tue Dec 06 08:42:53 CST 2016

Total time taken to generate the page: 0.12624 seconds