Technicalsymposium.com-Free Email Alerts


Enter Your Email :

Important Note:Login & Check Your Email Inbox and Activate Confirmation Link

Subscribe & Get All Fresher Jobs Information & Study Materials PDF and Projects- Free Download

DBMS Study Notes PDF


DBMS Tech Interview Q & A PDF


DBMS Latest Projects



DBMS Projects & All Latest Projects PDF- Free Download

PL SQL Program For function to return the grade of the student.

create or replace function ret_grade(no in number) return varchar2 is
grade varchar2(20);
mark1 integer;
mark2 integer;
mark3 integer;
average number(5,2);
begin
select m1,m2,m3 into mark1,mark2,mark3 from student where stuid=no;
average:=(mark1+mark2+mark3)/3;
if(mark1<50 or mark2<50 or mark3<50) then
return('FAIL');
elsif(average>=90) then return('A+');
elsif(average>=80) then return('A');
elsif(average>=70) then return('B');
elsif(average>=60) then return('C');
else
return('D');
end if;
end;

 

Download All DBMS Study Materials & ebook PDF



DBMS