Re: cumulative of a variable

anithaven_at_gmail.com wrote:
> hi,
>
> suppose i have three variables with repeated records
> year own_no age
> 2001 5 21
> 2001 5 21
> 2001 5 21
> 2002 5 21
> 2002 5 21
> 2003 5 21
> 2003 5 21
>
>
> how do i update the age variable as per year

What you are asking is incomprehensible. What 3 variables? What repeated records? In SQL? In PL/SQL? In what version of what product (you did post to c.d.o.misc)?

Provide a code example of your best attempt so far and explain what it is doing incorrectly.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org