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 do I restart sql?

968

---

What is a full join?

974

---

What is the order of sql select?

1041

---

How do I partition a table in sql?

1128

---

What is assignment operator in pl sql?

1035

---

What are the triggers associated with image items?

1042

---

Explain the order of sql statement execution?

1043

---

What are the 3 modes of parameter?

1154

---

what is the difference between a web-garden and a web-farm? : Sql dba

1081

---

What is the process of debugging?

1068

---

write an sql query to find names of employee start with 'a'? : Sql dba

1027

---

How do I order columns in sql?

1004

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

---

Why truncate is used in sql?

1003

---

what is a tablespace? : Sql dba

1049

---