下面这个代码怎么老出错?高手能帮我改一下吗,感激不尽!
2/15 PLS-00103: 出现符号 ")"在需要下列之一时: := . ) , @ % default character 符号 ")在 ")" 继续之前已插入。
================================
create or replace function get_module_average (
avgttl number)
return number is v_sal number(4);
begin
select a.avgcw*b.cwweight*0.01 + a.avgexam*b.examweight*0.01 avgttl
from (select year,
semester,
moduleid,
avg(cw) avgcw,
avg(exam) avgexam
from Registration
group by year, semester, moduleid) a,
module b
where a.moduleid = b.moduleid
and b.moduletitle='Introduction to Painting'
and a.semester='1'
and a.year='05';
return v_sal;
exception when no_data_found then
return 0;
when others then
return -1;
end;
2/15 PLS-00103: 出现符号 ")"在需要下列之一时: := . ) , @ % default character 符号 ")在 ")" 继续之前已插入。
================================
create or replace function get_module_average (
avgttl number)
return number is v_sal number(4);
begin
select a.avgcw*b.cwweight*0.01 + a.avgexam*b.examweight*0.01 avgttl
from (select year,
semester,
moduleid,
avg(cw) avgcw,
avg(exam) avgexam
from Registration
group by year, semester, moduleid) a,
module b
where a.moduleid = b.moduleid
and b.moduletitle='Introduction to Painting'
and a.semester='1'
and a.year='05';
return v_sal;
exception when no_data_found then
return 0;
when others then
return -1;
end;
select a.avgcw*b.cwweight*0.01 + a.avgexam*b.examweight*0.01 avgttl into v_sal