Newer
Older
GHFX_REFACTOR / SQL / V0_0_115__EQUIPMENT_TRI.sql
xiaowei on 11 Jan 2018 178 bytes 上传脚本
create or replace TRIGGER equipmentit
BEFORE INSERT ON equipment
FOR EACH ROW

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