17,377
社区成员
发帖
与我相关
我的任务
分享
create table test_aaa
(
id number(11),
name varchar2(100),
status number(2)
);
create table test_bbb
(
aaa_id number(11),
id number(11),
name varchar2(100),
status number(2)
);
--创建触发器
CREATE OR REPLACE TRIGGER test_trigger
after insert or update or delete OF STATUS ON test_bbb
DECLARE
BEGIN
--触发器代码
UPDATE TSET_AAA A SET A.STATUS = (SELECT MIN(STATUS) FROM TEST_BBB B WHERE B.AAA_ID = A.ID);
END;
UPDATE TEST_BBB B SET B.STATUS = 1 WHERE B.ID = 2;
UPDATE TEST_BBB B SET B.STATUS = 0 WHERE B.ID = 2;
select t.*,rowid from test_aaa t;
select t.*,rowid from test_bbb t;
以上是我写的例子,请参考