Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Working with huge tables of chronological data
Mladen Gogala schrieb:
> On Fri, 06 Apr 2007 22:45:44 +0100, Jonathan Lewis wrote:
>
>> Correct, the option using the analytic lag() would only give you the >> adjacent pairs.
Actually, lag() has an "offset" argument since 8i, nevertheless, lag() seems not to be suitable to find *all* consecutive pairs.
Best regards
Maxim Received on Sat Apr 07 2007 - 02:41:47 CDT