Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> trending growth, next increment

trending growth, next increment

From: Bob <orcl_at_comcast.net>
Date: Wed, 29 Nov 2006 09:17:05 -0500
Message-ID: <456D9661.2050009@comcast.net>


Is there a way to find the trending growth (next increment) difference between a defined list of values ie

1 , 2, 3, 4, 5  -- the next increment would be 1
5,4,3,2,1   -- the next increment would be -1
2,4,6,8,10 -- the next increment  would be 2
20,15,25,10,30  -- the next increment would be 10

I dont want to subtract base values, so if the base value were lower than the previous value, the lower value would re establish the counter.

I would use to get trending growth of tablespaces, in this example over a 5 month period

Thanks
Bob

-- 
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2006 - 08:17:05 CST

Original text of this message

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