Join Our Email Alerts-Subscribe
Important Note:Login & Check Your Email Inbox and Activate Confirmation Link

Enter Your Email :

Copyright Disclaimer:
Section 107 of the Copyright Act Fair Use Contents .
We are forwarding content link(s) from our website to content website & We are not serving any contents.
Main the Content PDF link(s) is/are obtained from GoogleSearch
for the purpose of Education & Teaching Intention. Not for commercial purpose. is not liable/responsible for any copyright issues.

DBMS Programming Source Codes & Study Notes-Free Download

Free Download of All Study Materials & ebooks PDF-Click & Download

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

create or replace function gradeall return varchar2 is
cursor c is select m1,m2,m3 from student;
mark1 integer;
mark2 integer;
mark3 integer;
average number(5,2);

open c;
fetch c into mark1,mark2,mark3;
exit when c%notfound;
if(mark1<50 or mark2<50 or mark3<50) then
elsif(average>=90) then return('A+');
elsif(average>=80) then return('A');
elsif(average>=70) then return('B');
elsif(average>=60) then return('C');
end if;
end loop;
close c;
end; Study Materials PDF-Download All Study Notes PDF Live Support-Chat with Our Experts

Official Contact: +91-9245556793 (Whatsapp Message / SMS / Voice Call)

Our Expert team is ready to answer all your questions immediately-Feel free to speak in Tamil/English.

(Example:Events info/Lecture Notes/Off-Campus & All Jobs/Projects & All education information)

Working hrs (IST): (Morning: 10:00AM-3:00 PM) and (Evening:5:00 PM to 10:00 PM)

All Latest Question & Answer Page (FAQ)-Click here