Re: Look ahead 2 rows

From: Yong <yhuang_at_slb.com>
Date: 2000/07/12
Message-ID: <8kijrs$s0p$1@news.sinet.slb.com>#1/1

There's no way for Oracle to do that. You have to write code to do it.

If your primary key is a sequence-generated number, you might consider using that. But still you have to store the current record set in your program variable (an array if more than one column is selected) before you select the next row based on that next primary key.

Yong Huang

craibuc <craibucNOcrSPAM_at_hotmail.com.invalid> wrote in message news:05986872.0b958be7_at_usw-ex0105-035.remarq.com...
> When processing a cursor, I need to look ahead two rows from the
> current row to compare values. What's the syntax for doing this?
>
> Craig Buchanan
> Cogniza, Business Intelligence Specialists
> www.cogniza.com
> +1.612.824.5858
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Wed Jul 12 2000 - 00:00:00 CDT