Yes, analytic functions do this. They operate on a "window" of data within the result set.
http://download-west.oracle.com/docs...htm#sthref1047
For example, the expression ...
Code:Sum(T_PPV_ORDER.PRICE) Over (Rows Between Unbounded Preceeding And Current Row) cume_price ...




Reply With Quote