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