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

How to set up sql*plus output format in oracle?

1013

---

how to include character strings in sql statements? : Sql dba

1044

---

What is dense_rank?

920

---

How do I partition a table in sql?

1100

---

How do I find sql profiler?

921

---

How can a pl sql block be executed?

930

---

What is nosql example?

1012

---

What is graph sql?

970

---

How do you update sql?

953

---

How to connect a sql*plus session to an oracle server?

1109

---

What is use of term?

1040

---

Explain how to use transactions efficiently : transact sql

953

---

What is sqlerrd?

955

---

What are the two virtual tables available at the time of database trigger execution?

1198

---

Explain what is rdbms?

1017

---