数据库原理与应用函数视图游标

Question

掌握视图 函数 游标的使用

Answer 1

表明 ：scores 字段：no,name,sex,birthday,major,score
1.
create view vw_score as
select no,name,sex,birthday,major,score from scores；
2.
create or replace function jiecheng(a number) return number is
b number:=1;
begin
for i in 1..a loop
b:=b*i;
end loop;
return b;
exception
when others then
dbms_output.put_line("程序运行错误!");
end jiecheng;
3.
declare
a number;
begin
select max(score) into a from scores;
dbms_output.put('name '||'score '||'最高成绩'||chr(10));
for i in (select name,score from scores where score<> (select max(score) from scores) ) loop
dbms_output.put(i.name||' '||i.score||' '||a||chr(10));
end loop;
dbms_output.put_line('');
end;