PL/SQL Trigger to Insert Salary more than 10000

PL/SQL Trigger to Insert Salary more than 10000:

create or replace trigger vali
before insert
on emp
for each row
begin
if(:new.salary < 10000)then
raise_application_error(-20000,'Salary must be greater than 10000');
end if;
end;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.