没有合适的资源?快使用搜索试试~ 我知道了~
pl/sal Create or replace trigger delete_student After delete on student For each row Begin Insert into backstudent values(:old.sno,:old.sname,:old.ssex,:old.sage,:old.sdept,:old.Birthday,sysdate); end delete_student; /
资源推荐
资源详情
资源评论
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('1','徐慧','女',19,'经管');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('2','李平','男',21,'材料');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('3','林虎','男',22,'飞制');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('4','张飞','女',20,'计算机');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('5','王二','女',21,'土木');
insert into sc(sno,cno,grade) values('1','5','');
insert into sc(sno,cno,grade) values('1','5','69');
insert into sc(sno,cno,grade) values('1','','69');
select * from student;
create table student
( Sno char(9) primary key,
Sname char(20) ,
Ssex char(6),
Sage smallint,
Sdept char(20)
);
create table sc
( Sno char(9) primary key,
Cno char(6),
grade smallint,
)
drop table student cascade constraints;
drop student;
*****************************************************************************************************************
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('2','李平','男',21,'材料');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('3','林虎','男',22,'飞制');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('4','张飞','女',20,'计算机');
insert into student(Sno,Sname,Ssex,Sage,Sdept) values('5','王二','女',21,'土木');
insert into sc(sno,cno,grade) values('1','5','');
insert into sc(sno,cno,grade) values('1','5','69');
insert into sc(sno,cno,grade) values('1','','69');
select * from student;
create table student
( Sno char(9) primary key,
Sname char(20) ,
Ssex char(6),
Sage smallint,
Sdept char(20)
);
create table sc
( Sno char(9) primary key,
Cno char(6),
grade smallint,
)
drop table student cascade constraints;
drop student;
*****************************************************************************************************************
资源评论
qq_27818795
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功