Hi, Could any one show me how to write the following
function? Thank you very, very much!
The GPA Function
1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.
Andrea,
Here is a version of the function you asked for, IT IS NOT WELL
TESTED, should give you something to go on.
Scott Crabtree
FUNCTION calc_avg (student_id IN NUMBER)
RETURN NUMBER
AS
CURSOR student_c
IS
SELECT snum
|| call# class, credit, RTRIM
