CREATE OR REPLACE TRIGGER casic_loginfoit BEFORE INSERT ON casic_loginfo FOR EACH ROW when (NEW.LOGID IS NULL) BEGIN SELECT casic_loginfois.NEXTVAL INTO:NEW.LOGID FROM DUAL; END;