CREATE OR REPLACE TRIGGER casic_userinfotestit BEFORE INSERT ON casic_userinfotest FOR EACH ROW when (NEW.ID IS NULL) BEGIN SELECT casic_userinfotestis.NEXTVAL INTO:NEW.ID FROM DUAL; END;