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 primary use of normalization?
Why indexing is needed?
What is the benefit of foreign key?
Explain what is rdbms?
What is the order of sql select?
Why do you partition data?
What is information schema in sql?
What is normalization in a database?
What are different types of sql?
Why having clause is used in sql?
What is right join in sql?
What is full form of rtm?
How long does it take to learn pl sql?
What are %type and %rowtype for?
What are the methods of filing?
