Newer
Older
GHFX_REFACTOR / SQL / V0_0_214__CASIC_AUDIT_RESULT_TRI.sql
xiaowei on 11 Jan 2018 200 bytes 上传脚本
CREATE OR REPLACE TRIGGER CASIC_AUDIT_RESULTIT
BEFORE INSERT ON CASIC_AUDIT_RESULT
FOR EACH ROW

when (NEW.DBID IS NULL)
BEGIN
    SELECT CASIC_AUDIT_RESULTIS.NEXTVAL INTO:NEW.DBID FROM DUAL;
    END;