那用包头作一个全局变量,记录触发器触发次数。CREATE OR REPLACE PACKAGE pkg_test AS v_recordcount number:=0; END pkg_test; / create or replace trigger name_tri before update on table for each row as begin pkg_test.v_recordcount:=pkg_test.v_recordcount+1; end name_tri; /
对楼上的建议补充两句: 为了保证是对同一SQL语句结果的统计,可以再为此table增加一语句级触发器: create or replace trigger name_tri_after after update on table begin -- 先使用pkg_test.v_recordcount
pkg_test.v_recordcount:=0; --清零 end name_tri_after; /
AS
v_recordcount number:=0;
END pkg_test;
/
create or replace trigger name_tri
before update on table
for each row
as
begin
pkg_test.v_recordcount:=pkg_test.v_recordcount+1;
end name_tri;
/
为了保证是对同一SQL语句结果的统计,可以再为此table增加一语句级触发器:
create or replace trigger name_tri_after
after update on table
begin
-- 先使用pkg_test.v_recordcount
pkg_test.v_recordcount:=0; --清零
end name_tri_after;
/