Hi everyone,
I want to Write a trigger that will limit a user to enter only numeric values between 100 and 200 into a field called bonus for the table empBonus. and I have created trigger so please check for me that where I made mistake.
thank you.
trigger as under which i wrote.
create or replace trigger bonus_chk
before insert on empbonus
for each row
declare
emp_id number(3) := &emp_id;
emp_name varchar2(20) := '&emp_name';
emp_sal number(5) := &emp_sal;
emp_bonus number(3) := &emp_bonus;
begin
if emp_bonus < 100 or &emp_bonus > 200 then
raise_application_error(-20001,' Employee's bonus must be in between 100 to 200);
else
insert into empbonus
values
(&emp_id, '&emp_name','&emp_sal','&emp_bonus');
dbms_output.put_line('One row created successfully !');
end if;
end;