例如a表里有id did 删除后删除关联的b,d,d
删除b表关联的did=id
删除c表中的did=did
删除d表中的did=did
第1个回答 2011-12-31
把A表did 设置为主键,B,C,D表中的did设置为唯一键,并和A表的主键进行关联,设置级联删除,OK~
第2个回答 2011-12-23
create or replace trigger terminaltype_update_saMenuVer
before update on TBL_TERMINALTYPE_INF
for each row
declare
nextid number;
begin
select sequence_termtype_saMenuVer.nextval
into nextid
from dual;
:new.saMenuVer:=nextid;
end terminaltype_update_saMenuVer ;本回答被提问者和网友采纳
before update on TBL_TERMINALTYPE_INF
for each row
declare
nextid number;
begin
select sequence_termtype_saMenuVer.nextval
into nextid
from dual;
:new.saMenuVer:=nextid;
end terminaltype_update_saMenuVer ;本回答被提问者和网友采纳