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 the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

How do I view a sql database?

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Can function return multiple values in sql?

0 Answers  

---

Explain cursor types?

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---

What is the use of function "module procedure" in pl/sql?

0 Answers  

---

What is the difference between microsoft access and sql?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

what are the types of subquery? : Sql dba

0 Answers  

---

What is aggregate function in sql?

0 Answers  

---