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

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

what is the difference between granting and creating a view?

2 Answers  

---

what is global variable in pl/sql

1 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

is it possible to pass an object or table to a procedure as an argument?

1 Answers  

---

What is column?

1 Answers  

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

what is the difference between $message and $$message? : Sql dba

1 Answers  

---

Can sql developer connect to db2?

1 Answers  

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

what are the forced views

6 Answers   Hexaware, TCS,

---