1.第一关 创建视图(1)
create view T_Sub
as
select tno,tname,sex,title
from teacher
where title='副教授'
2.第二关 创建视图(2)
create view C_S
as select gname,cname,teacher.tno
from class,course,teacher,teaching
where class.dept='软件' and teacher.tno=teaching.tno and teaching.cno=course.cno and class.gno=teaching.gno
3.第三关 查询视图
select gname,cname
from C_S
4.第四关 删除视图
drop view C_S
5.第五关 视图的添加操作
insert into T_Sub
values('0296','赵梦','女','副教授')
6.第六关 视图的修改操作
update T_Sub
set title='教授'
where tname='赵梦'
7.第七关 视图的删除操作
delete from T_Sub
where tname='覃刚'
8.第八关 创建索引
create unique index TI on teacher(tname)
9.第九关 查看索引
SELECT * FROM user_indexes
WHERE table_name=upper('teacher') ;
10.第十关 修改索引
alter index TI
rename to TTI
11.第十一关 删除索引
drop index TTI