Answer Posted / 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.

what are the advantages of sql ? : Sql dba

1142

---

Is inner join faster than left join?

1277

---

What is the current version of postgresql?

1178

---

what are aggregate and scalar functions? : Sql dba

1129

---

define sql insert statement ? : Sql dba

1098

---

What is the best sql course?

1050

---

Does group by remove duplicates?

1112

---

Can we use distinct and group by together?

1133

---

what is collation? : Sql dba

1229

---

How do I remove duplicates in two columns?

1187

---

If a cursor is open, how can we find in a pl/sql block?

1238

---

what are all the common sql function? : Sql dba

1131

---

Do we need to rebuild index after truncate?

1138

---

what is sql server agent? : Sql dba

1182

---

what is bcp? When does it used? : Sql dba

1056

---