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

Write a sql query to get the third highest salary of an employee from employee_table?

1119

---

Define concurrency control. : Transact sql

1236

---

What is the difference between instead of trigger and after trigger?

1067

---

Why is normalization important?

1082

---

What is a sql profiler?

1066

---

What are the differences between in and exists clause?

1166

---

Is sqlite thread safe?

1102

---

What are all the ddl commands?

1244

---

What are the packages in pl sql?

1066

---

Is sql between inclusive?

1199

---

What is nosql db?

1014

---

what is csv? : Sql dba

1050

---

What is pl sql commands?

1097

---

What is the purpose of design view?

1077

---

What are the rules to be applied to nulls whilst doing comparisons?

1369

---