create or replace trigger ATOB after insert or update on A for each row
begin
if inserting then
insert into b values(:new.col1,:new.col2,...,:new.coln);
else
update b set (col1,col2,...,coln)=(select :new.ccol1,:new.col2,...,:new.coln from dual)
where 关联字段=:old.关联字段;
end if;
end;
begin
if inserting then
insert into b values(:new.col1,:new.col2,...,:new.coln);
else
update b set (col1,col2,...,coln)=(select :new.ccol1,:new.col2,...,:new.coln from dual)
where 关联字段=:old.关联字段;
end if;
end;
没有这样的用法吗?:new.*
请问楼上大哥知道其中含义吗
create table tableb as select * from tableA where 0=1;
为什么要
update b set (col1,col2,...,coln)=
(select :new.ccol1,:new.col2,...,:new.coln from dual)
不能直接
update b set (col1,col2,...,coln)=
(:new.ccol1,:new.col2,...,:new.coln)
还有什么写法啊?