Re: Iterative Calculations
Date: Fri, 14 Aug 2009 16:54:43 +0200
"Hans Mayr" <mayr1972_at_gmx.de> a écrit dans le message de news: 175b9dc2-db4a-4fab-855a-276439402249_at_e27g2000yqm.googlegroups.com...
| 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) +
| Thanks and best,
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.
Michel Received on Fri Aug 14 2009 - 09:54:43 CDT