(1)create table sc (sno not null,cno not null,grade)
(2)select * from student where sname like '司马%'
(3)create view PC_view WITH ENCRYPTION AS select * from student shere sdept='计算机系'
(4)grant alter,insert on student to U1
(5)select sname ,sno from student s,course c,sc a where a.sno=s.sno and c.cno=a.cno and
c.cname='数据库原理及应用' order by s.sno desc
出的题不严谨啊，居然不告诉数据类型，楼上的建表没加数据类型
1、
create table sc
(
sno varchar(10) not null,
cno varchar(10) not null,
grade int
)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024