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 pl sql script?

0 Answers  

---

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

0 Answers  

---

What are character functions?

0 Answers  

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

What does seeding a database mean?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

What are the types pl/sql code blocks?

0 Answers  

---

What is sap sql?

0 Answers  

---

How to run sql*plus commands in sql developer?

0 Answers  

---

How do I count rows in sql?

0 Answers  

---