Newer
Older
GHFX_REFACTOR / SQL / V0_0_246__CASIC_USERINFOTEST_TRI.sql
xiaowei on 11 Jan 2018 196 bytes 上传脚本
CREATE OR REPLACE TRIGGER casic_userinfotestit
BEFORE INSERT ON casic_userinfotest
FOR EACH ROW

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