create or replace trigger tWyplata BEFORE UPDATE or INSERT on pracownik for each row
DECLARE
maxi number:=6000;
mini number:=1200;
begin
if :new.pensja > maxi then
:new.pensja:= maxi;
end if;
if :new.pensja <mini then
:new.pensja:= mini;
end if;
end;