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: SQL to generate percentage growth per time period?

Re: SQL to generate percentage growth per time period?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 02 Dec 2007 20:51:00 +0100
Message-ID: <47530CA4.4020206@gmail.com>


Digeratus 2006 schrieb:
>
> I thimk that you want to know the weekly change between data values.
> You want to compare values of data from two distinct rows. You cannot
> do this easily using SQL. You need to use PL/SQL to do this.

I think, however, this task can be relatively easy done in SQL (and probably more easy than in PLSQL - i mean analytical functions) at least since 8iR2.

Best regards

Maxim Received on Sun Dec 02 2007 - 13:51:00 CST

Original text of this message

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