如题~~~~~~~
--创建测试表
create table test(t varchar2(20));
create table ttt(t varchar2(20));
--创建物化视图
create materialized view mv_test refresh with rowid FORCE ON DEMAND start with sysdate next sysdate as select * from test;
--创建触发器
drop trigger oversee_test;
create or replace trigger oversee_test
before insert or update or delete on mv_test
begin
insert into ttt(t)values('1t');
end
end oversee_mv_sodetail
--创建测试表
create table test(t varchar2(20));
create table ttt(t varchar2(20));
--创建物化视图
create materialized view mv_test refresh with rowid FORCE ON DEMAND start with sysdate next sysdate as select * from test;
--创建触发器
drop trigger oversee_test;
create or replace trigger oversee_test
before insert or update or delete on mv_test
begin
insert into ttt(t)values('1t');
end
end oversee_mv_sodetail
commit一下试试。
或者像这样建立一个触发器:
create or replace trigger ai_order_tab
after insert on order_tab for each row
declare
pragma autonomous_transaction;
begin
update order_tran_coming_in
set success_flag = 'Y'
where order_id = :NEW.order_id;
commit;
end;
/
自治事务 pragma autonomous_transaction 可以加commit