Answer Posted / koteswara reddy
If row level trigger based on a table than trigger body cannot read data from same table and also we can't perform dml operations on a same table. if anybody trying this then oracle server returns an error. this error is called mutating error and table is called mutating table
ex:-
create or replace trigger trg
after delete on emp
for each row
declare
l_count number;
begin
select count(*) into l_count from emp;
dbms_output.put_line(l_count);
end;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the cause of mutating table error and how can we solve it?
what is blob? : Sql dba
Why do we use sqlite?
What are the two different parts of the pl/sql packages?
Why we use cross join?
What is sql server and ase?
How do I view a sql trace file?
What is use of term?
What are the 3 modes of parameter?
Explain the difference between drop and truncate commands in sql?
How many types of privileges are available in sql?
What is on delete set null?
What are the two types of cursors in pl sql?
What are the types of join and explain each?
How do I run sql profiler?
