Visszajelzés

create or replace TRIGGER emp_uj_dolgozo_trigger
BEFORE INSERT ON emp
FOR EACH ROW
DECLARE
v_minfiz EMP.sal%TYPE;
BEGIN
    SELECT MIN(sal) INTO v_minfiz FROM emp WHERE deptno = :NEW.deptno;
   :NEW.sal := v_minfiz;
END;