Re: How would you test this function

Dunno if you want to know how to test from a 'technical' point of view. If so

SET SERVEROUT ON
DECLARE
  v_retval NUMBER;
begin
  v_retval = Median_Grade(1, 2, 3);
  dbms_output.put_line(v_retval);
END; Or from SQL*Plus

SQL> SELECT Median_Grade(1, 2, 3) FROM DUAL;

If its testing the logic, see Jims Post ;-)

M

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<pDAS7.642$MM5.323802_at_rwcrnsc53>...
> Create the necessary table , add data , calculate the median by hand, run
> the function. Use both an odd and an even number of grades. Also do it
> with no grades.
> Jim
Received on Mon Dec 17 2001 - 04:44:06 CST