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 are joins in sql?

0 Answers  

---

Why do we need cursors in pl sql?

0 Answers  

---

What is a primary key sql?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

Explain aggregate functions are available there in sql?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

What is the difference between union and union all command?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

How do you add a column to a table?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---