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: Mladen Gogala <mgogala.SPAM-ME.NOT_at_verizon.net>
Date: Sat, 7 Apr 2007 01:36:15 +0200 (CEST)
Message-ID: <pan.2007.04.06.23.32.32@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 Fri Apr 06 2007 - 18:36:15 CDT

Original text of this message

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