Answer Posted / pravin more

Mutating error in Trigger:-
When programmer create trigger and give table name abc and
in body if programmer is using same table abc for
selecting,updating,deleting,inserting then mutation occur.
ex.:-
create or replace trigger xyz
after
update
on abc
for each row
referencing :OLD as OLD :NEW as NEW
begin
select max(salary) from abc;

update abc
set location_id=:NEW.location_id
where dept_id=105;

end;
------------------------------------------------------------
In the above example you are updating same table which is
under transaction so mutation problem occur here.

Solution on this is
You can use Temporary table or Materialize view which can
solve above problem

Can we connect to postgresql using sql developer?

1048

---

Can we use update in sql function?

1115

---

what are myisam tables? : Sql dba

1077

---

How is indexing done in search engines?

1021

---

How many types of cursors supported in pl/sql?

1256

---

How can we solve sql error: ora-00904: invalid identifier?

1293

---

What is duration in sql profiler trace?

1140

---

Can we rename a column in the output of sql query?

1039

---

I need a function for a train ticket reservation please answer it thanks in advance

1078

---

How to convert comma separated string to array in pl/sql?

1240

---

Does execute immediate commit?

1290

---

What are the different types of a subquery?

1102

---

Which sql most popular?

1029

---

What is posting?

1083

---

Explain the difference between 'between' & 'and' operators in sql

1044

---