删除数据

delete 【form 】【schema.】表名【where condition】
schema.:用户模式 例如 zhou.student
condition:删除添加/表达式/字句

删除案列1

删除案列2

create table class(
cno varchar2(10) primary key,
cname varchar2(20),
cnum number(2)
);

create table student2(
sno varchar2(10) primary key,
sname varchar2(20),
sage number(2),
cno varchar2(2),
constraint fk_sno foreign key(cno) references class(cno) on delete cascade
);

insert into student2 values(‘2’,’lili’,18,’1’);
insert into student2 values(‘3’,’lili’,18,’1’);
insert into student2 values(‘4’,’lili’,20,’1’);
insert into student2 values(‘5’,’lili’,21,’1’);

delete from student2 where sname=’lili’

转载于:https://www.cnblogs.com/feiZhou/p/9344397.html