Answer / kishore

yes........

create or replace trigger emp_biu
before insert or update on employee
referencing new as new old as old
for each row
begin
if nvl(:new.salary,0) >= 10000 then
raise_application_error (-20999,'Salary with
commissions should be less than 10000');
end if;
end;
/

What is rownum?

0 Answers  

---

What are transaction and its controls?

0 Answers  

---

Is sql a microsoft product?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

What is the usage of sql functions?

0 Answers  

---

How do you retrieve the last N records from a table?

10 Answers  

---

What is a trigger in sql?

0 Answers  

---

What is auto increment in sql?

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

How many types of sql are there?

0 Answers  

---