Re: Iterative Calculations
Date: Fri, 14 Aug 2009 17:29:48 +0200
Message-ID: <4a8582ec$0$22539$426a74cc_at_news.free.fr>
"Michel Cadot" <micadot{at}altern{dot}org> a écrit dans le message de news: 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
|
|
See the discussion in the following thread: http://www.orafaq.com/forum/mv/msg/125507/350586/102589/#msg_350586
Regards
Michel
Received on Fri Aug 14 2009 - 10:29:48 CDT