SQL> create or replace function average (cno in char)
2 return number
3 as
4 average number;
5 begin
6 select avg(成绩) into avger from course
7 group by cno;
8 return(avger);
9 end;
10 /
警告: 创建的函数带有编译错误。
2 return number
3 as
4 average number;
5 begin
6 select avg(成绩) into avger from course
7 group by cno;
8 return(avger);
9 end;
10 /
警告: 创建的函数带有编译错误。