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 are sequences

1618

---

What are the qualities of 2nf?

975

---

Explain sql data types?

1035

---

Explain how to use transactions efficiently : transact sql

922

---

What type of database is cloud sql?

1044

---

Is coalesce faster than isnull?

906

---

What does data normalization mean?

896

---

what is a foreign key ? : Sql dba

1025

---

what are myisam tables? : Sql dba

950

---

What is difference between sql and excel?

1006

---

What are different types of sql commands?

1023

---

Does db2 use sql?

888

---

Why do we need unique key in a table?

882

---

How can you fetch common records from two tables?

1000

---

Is it possible for a table to have more than one foreign key?

976

---