Question

oracle SQL触发器比较两个表中的数据

当在Diner表中插入一个新值得时候，比较两个表中的table_seating_capacity和 diner_seat_no.如果diner_seat_no大的话则输出一段话.

Answer 1

CREATE OR REPLACE TRIGGER trg_A
after update
of aa
ON a
referencing new as new old as old
for each row
declare

begin
if :new.aa<>:old.aa then
update B set aa=:new.aa where A.XX=B.XX;
end if;

exception
when others then
null;
end trg_A;