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 is parallel hint?

1223

---

Is record in pl sql?

918

---

What do you understand by exception handling in pl/sql?

967

---

What are the key differences between SQL and PL SQL?

1149

---

How many types of normalization are there?

901

---

what are date and time data types? : Sql dba

933

---

How do I run a program in pl sql?

953

---

What is use of term?

1009

---

How delete all data from table in sql?

951

---

discuss about myisam index statistics collection. : Sql dba

908

---

What is substitution variable in pl sql?

981

---

what is sql server agent? : Sql dba

1030

---

What is file based approach?

877

---

What is cartesian join in sql?

1030

---

what is heap table? : Sql dba

1049

---