Re: Iterative Calculations

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 14 Aug 2009 16:54:43 +0200
Message-ID: <4a857ab2$0$287$426a74cc_at_news.free.fr>


"Hans Mayr" <mayr1972_at_gmx.de> a écrit dans le message de news: 175b9dc2-db4a-4fab-855a-276439402249_at_e27g2000yqm.googlegroups.com...
| Hello,
|
| I have a table that contains the fields PERIOD, STOCK, NEW_UNITS,
| CHURN_RATE. STOCK is only available for a given start period. I want
| to update the expected stock of the next periods. Is there a way that
| in pure SQL (without PL SQL and a cursor) I can calculate
|
| STOCK of PERIOD (N) = STOCK of PERIOD (N-1) * (1-CHURN_RATE) +
| NEW_UNITS
|
| ?
|
| Thanks and best,
|
| Hans

If you post a test case (create table and insert statements) maybe we can help more. It seems to be a good example for MODEL clause although it may be possible to do it with CONNECT BY depending on the exact case.

Regards
Michel Received on Fri Aug 14 2009 - 09:54:43 CDT

Original text of this message