觸發器示例

create or replace TRIGGER "abcd".abcd_PERFORMANCE_TRIGGER1

BEFORE INSERT

ON abcd_PERFORMANCE

REFERENCING NEW AS New OLD AS Old

FOR EACH ROW

DECLARE

BEGIN

  :NEW.DBUSAGE := SNMP_REPORT_DB_USAGE();

  :NEW.SAMPLETIME := SNMP_SAMPLE_TIME_5m(:NEW.SAMPLETIME);

  EXCEPTION

     WHEN OTHERS THEN RAISE;

END;

本文轉自 jxwpx 51CTO部落格，原文連結：http://blog.51cto.com/jxwpx/193874，如需轉載請自行聯系原作者