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;
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，如需转载请自行联系原作者
