Re: Method in oracle

From: anacedent <anacedent_at_hotmail.com>
Date: Sun, 23 May 2004 12:34:52 -0700
Message-ID: <x17sc.14082$wa.10638@fed1read07>

Profetas wrote:
> Hi I have this function
>
> CREATE TYPE BODY licence_t AS MEMBER FUNCTION get_penalty_points RETURN
> INTEGER IS
> p number;
> y number;
> BEGIN
> select z.penalty_p into p from conv_speed z, licence a where z.speed_li =
> ref(a) ;
> return y = y + p;
> END get_penalty_points;
> END;
> /
>
> My goal is to sum the values of a tuple that belong to a person ID into
> P.
>

So why don't you use the SUM function? Received on Sun May 23 2004 - 14:34:52 CDT