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

What are the types of dbms?

974

---

what are set operators in sql? : Sql dba

1052

---

What is form and report?

986

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

952

---

What is database migration?

967

---

What is an implicit commit?

1054

---

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

---

What is on delete set null?

1088

---

what is commit? : Sql dba

1073

---

What kind of join is join?

969

---

how can we submit a form without a submit button? : Sql dba

986

---

What is package in pl sql?

1025

---

What is recursive stored procedure?

1099

---

How do you rename a table in sql?

1111

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1165

---