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

Home -> Community -> Usenet -> c.d.o.server -> Re: Working with huge tables of chronological data

Re: Working with huge tables of chronological data

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 7 Apr 2007 09:54:56 +0100
Message-ID: <JdudncAvW7tKwYrbnZ2dnUVZ8sOonZ2d@bt.com>

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Mladen Gogala" <mgogala.SPAM-ME.NOT_at_verizon.net> wrote in message 
news:pan.2007.04.06.23.32.32_at_verizon.net...

> 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, it wouldn't. In version 10g, lag has an "offset" argument
> which would tell you by how much is it trailing.
>
> --
> http://www.mladen-gogala.com
Received on Sat Apr 07 2007 - 03:54:56 CDT

Original text of this message

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