Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cumulative of a variable

Re: cumulative of a variable

From: T <t_at_yahoo.com>
Date: Tue, 13 Jun 2006 08:40:00 +0200
Message-ID: <e6lmm9$dbj$1@ss408.t-com.hr>

<anithaven_at_gmail.com> wrote in message
news:1149951451.368349.34970_at_f6g2000cwb.googlegroups.com...
> 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
>

try to select rowid id, year, own_no, age from table, maybe the rowid pseudocolumn is what you looking for.. Received on Tue Jun 13 2006 - 01:40:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US