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

What is the primary key?

952

---

What is identity column in sql server?

1048

---

how to run 'mysql' commands from a batch file? : Sql dba

1120

---

How to fix oracle error ora-00942: table or view does not exist

1015

---

What is the main reason behind using an index?

1017

---

What does subquery mean in sql?

1052

---

Is sql better than access?

1015

---

What are the events on which a database trigger can be based?

1189

---

what's the difference between a primary key and a unique key? : Sql dba

1050

---

Is oracel sql developer written in java?

1106

---

What is database white box testing and black box testing?

1111

---

What is a variable in sql?

1001

---

How does stored procedure reduce network traffic?

1008

---

Can sql developer connect to db2?

1048

---

What does over partition by mean in sql?

978

---