create or replace function findcourse(name_in in varchar2) return number; is
c_number number;
cursor c1 is
select stu_roll from student where stu_name = name_in;
begin
open c1;
fetch c1 into c_number;
if c1%notfound then c_number = 9696;
end if;
close c;
return c_number;
end;
Comments
Post a Comment