Interested to Buy Any Domain ? << Click Here >> for more details...
When the mutating error will comes? and how it will be
resolved?
- 2 Answers
- 7795 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is denormalization. : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
what is datawarehouse? : Sql dba
What are the steps for performance tuning.
Can you sum a count in sql?
What is a database trigger?
What do you mean by stored procedures? How do we use it?
How do I add a primary key to a table?
what are the advantages a stored procedure? : Sql dba
How many sql commands are there?
What are the types of functions in sql?
What is the difference between microsoft access and sql server?
Can we use joins in subquery?
What is dense_rank?
what is a composite key ? : Sql dba
