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;