oracle中有没有快捷点的方法进行级关联删除

你在b表建了外键关联a后难道删除主表数据，附表没删？

-- Create table
create table T
(
A VARCHAR2(32) default sys_guid() not null,
B VARCHAR2(11)
)
tablespace TEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table T
add constraint PK_T_A primary key (A)
using index
tablespace TEST
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

-- Create table
create table TT
(
A VARCHAR2(32) not null,
B VARCHAR2(32)
)
tablespace TEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table TT
add constraint PK_TT_A primary key (A)
using index
tablespace TEST
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table TT
add constraint FK_TT_B foreign key (B)
references T (A) on delete cascade;

上面两个表t主表，tt子表，你捉摸下，

这还能这么简单，直接写两个delete 就是了，删除不同表又不能只写一个delete
delete from dept where dept_id=1;
delete from user where dept_id=1;
这还不够简单？？

实际应用中应该使用触发器功能比较好