Answer Posted / purushottam

All the above suggested point is fine but addition on it is
when you are going to use the aggregate function for same
table then also be the mutating table error will occur.

example:

create table t(x numner);
/

create or replace trigger t_af_trigg
before insert into t
for each row
declare
n integer;
begin
select count(*) into n from t;
dbms_output.put_line('there are ' || n || ' rows in t');
end;
/

insert into t values(1);
error:
ORA-04091: table MISC.T is mutating, trigger/function may
not see it
ORA-06512: at "MISC.T_AF_TRIGG", line 5
ORA-04088: error during execution of trigger 'MISC.T_AF_TRIGG'

This example value addition of Vivek's suggession

"Mutating means that some one is trying to access the table
currently being held by some other non-committing
transaction(i.e. in Locked state)"

what is an extent ? : Sql dba

1073

---

Does sql profiler affect performance?

976

---

Does sap use sql?

963

---

What are the key differences between SQL and PL SQL?

1200

---

How do you pronounce sql?

988

---

How to display the records between two range in Oracle SQL Plus?

1135

---

What does an inner join do?

1161

---

How do you get column names only for a table (sql server)?

1141

---

What is a sql profiler?

1003

---

what is bcp? When does it used? : Sql dba

975

---

what are sequences

1723

---

What is use of term?

1045

---

How do temporal tables work?

939

---

What is query execution plan in sql?

1168

---

Why do we use procedures in pl sql?

1010

---