Answer / chandu

when we try to dml operation on orginal table in trigger.
then the trigger was excuted but while perfoming any action
on original table it will show mutating..

to overcome the above problem we need to create a autonamous
trasaction trigger..

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

Which command is used to delete a package?

0 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---

How would you pass hints to the sql processor?

0 Answers  

---

Are left and right joins the same?

0 Answers  

---

What is a scalar value in sql?

0 Answers  

---

Is sql the best database?

0 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

how to use in conditions? : Sql dba

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---