Re: Q: plsql cursor question ?

Hi.

 I think it's better to select rowid as well.  You can use the last rowid to update your last row.

  CURSOR cursor1 IS SELECT c1, rowid FROM mytable

• ORDER BY ????; lastrowid ROWID; BEGIN c1 :=0; lastrowid := NULL; tot := 0; FOR crs_rec IN cursor1 LOOP tot := tot + c1; END LOOP; tot :+ c1 * 300 + tot; UPDATE mytable SET c1 := tot WHERE rowid = lastrowid;

 HTH. Michael.

>
> tedchyn_at_yahoo.com wrote:
>
> > Sir,
> >
> > I have a table with following data
> >
> > c1
> > --
> > 100
> > 200
> > 300
> > accumulate total tot := c1 + tot
> > for last record tot:= c1 * 300 + tot
> >
> > since I do not know my which is my last record. I have to save the
> > number and accumulate total for the previous saved record and
> > continuing fetching until %notfound so I can process the last record
> > saved.
> >
> > how do I do that in pl/sql code ?
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 07:01:05 CST