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