Oracle 关联删除

一、数据准备:

--1）创建待删除的数据
create table stu
(
 sno varchar(20),
 sname varchar(40),
 sex varchar(20)
);
insert into stu values('s001','张磊','男');
insert into stu values('s002','宋飞','男');
insert into stu values('s003','王丽','女');
insert into stu values('s004','李娟','女');
commit;
--2)创建关联删除表数据
create table stu_del
(
 sno varchar(20),
 sname varchar(40),
 sex varchar(20)
);
insert into stu_del values('s001','张磊','男');
insert into stu_del values('s002','宋飞','男');
commit;

二、实现需求:

三、实现代码:

delete from stu s
where exists(
    select * from stu_del s1
    where s1.sno = s.sno
);
commit;