Answer / vishwa

Mutating means that some one is trying to access the table
currently being held by some other non-committing
transaction

Answer / saraswathi muthuraman

IF you have a trigger on table emp_test. Inside that
trigger, your are trying to update/insert in the same table
emp_test.
Then mutating table error will occur.

Answer / vijayakumar n

Trigger one executed again & again in a table.

Answer / udaykumar

specified set of records we can commit or commit or
rollback regardless of parent transactions.

Answer / swastik

*When Ever You Create a Trigger On a Table And Performing Any DML Operation in Side The Trigger Body On Same Table Then Mutating Error Will Come.
*Row Level Trigger It Will Happen

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

Explain the insert into statements in sql?

0 Answers  

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

Explain what is rdbms?

0 Answers  

---

What is difference sql and mysql?

0 Answers  

---

What is the meaning of disabling a trigger?

0 Answers  

---