GHFX_REFACTOR/GHFX_SQL/V0_0_222__CASIC_LOGINFO_TRI.sql at rkdw

Fork: 0

codedev / GHFX_REFACTOR

Find file

Newer

Older

GHFX_REFACTOR / GHFX_SQL / V0_0_222__CASIC_LOGINFO_TRI.sql

zhangfan on 26 Oct 2016 187 bytes 1. 完成拓扑分析、标注工具代码的重构

Raw Blame History

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;