PL SQL Program For adding total using funtion.

PL SQL Program For adding total using funtion. 


create or replace function fn(no in number)return varchar2 is 
msg varchar2(19);
cursor c1 is select m1,m2,m3 from student where stuid=no;
er c1 %rowtype;
begin
for er in c1 loop
return ('total scored' ||(c1.m1+c1.m2+c1.m3));
end loop;
end;