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

Why does sql need a server?

0 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

Why use subqueries instead of joins?

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

Is pl sql a programming language?

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---