ABE

create or replace trigger SUPP_BOSS
before insert or update of salary on employees
FOR EACH ROW
DECLARE
    SALAIRE_BOSS INT;
    PAS_SALL_SUPP_BOSS EXCEPTION;
begin
    select SALARY into SALAIRE_BOSS From EMPLOYEES where JOB='Boss';
    IF (:NEW.SALARY > SALAIRE_BOSS) THEN
        RAISE PAS_SALL_SUPP_BOSS;
    END IF;
    EXCEPTION
WHEN PAS_SALL_SUPP_BOSS THEN
	Raise_application_error(-20001,'PAS DE SALAIRE SUPERIEUR A CELUI DU BOSS !!!');
end;
/

insert into EMPLOYEES values(10,'Maggie',03,30000,'Technical');