查询视图时不用对文字列名加双引号
--(1)包含学生的学号、姓名、所在系、年龄,课程号、课程名、课程学分的视图。
create view s_view1(学号,姓名,所在系,年龄,课程号,课程名,课程学分)
as select student.Sno ,sname ,sdept ,sage ,course.Cno ,
cname ,Credit from Student,SC,Course
where Student.Sno = SC.Sno and
sc.Cno = Course.Cno
--(2)包含学生的学号、姓名、选修的课程名和考试成绩的视图。
create view s_view2(学号,姓名,选修课程名,考试成绩)
as select Student.Sno ,sname ,cname ,grade
from Student,SC,Course
where Student.Sno = sc.Sno and
sc.Cno