CREATE TRIGGER piwosz_auto BEFORE INSERT ON pijak FOR EACH ROW BEGIN SELECT NVL(MAX(ID_PIWOSZA)+1,1) INTO :NEW.ID_PIWOSZA FROM pijak; END;