创建视图:
create view xuesheng1
as
select 学号,姓名 from 学生
where exists (select 课程号 from 课程
where 课程号='C1' and exists (select 成绩 from 选课 where 系编号='D1'and 成绩<60 ));
创建存储过程:
create or replace procedure select_student
(cur out select_08)
as
begin
open cur for
select xh.xm,zym,xbcssj,zxf from xs
order by xh;
end;
创建触发器:
create trigger cs_kc_avg_del
instead of delete on cs_kc_avg for each row
begin
delete from xs_kc where xh=:old.xh;
end cs_kc_avg_del;
简单的用例仅供参考!