Newer
Older
GHFX_REFACTOR / SQL / V0_0_222__CASIC_LOGINFO_TRI.sql
xiaowei on 11 Jan 2018 187 bytes 上传脚本
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;