Newer
Older
GHFX_REFACTOR / GHFX_SQL / V0_0_222__CASIC_LOGINFO_TRI.sql
wxn on 2 Nov 2016 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;