Newer
Older
GHFX_REFACTOR / GHFX_SQL / V0_0_234__CASIC_USERDOCUMENT_TRI.sql
wxn on 2 Nov 2016 207 bytes 提交
CREATE OR REPLACE TRIGGER TRI_CASIC_USERDOCUMENT
  BEFORE INSERT ON CASIC_USERDOCUMENT
  FOR EACH ROW


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