Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is ROLLUP functionality part of baseline?
Hi Hans
> I've been looking in the docco for a definitive answer, but either need to
> replace my glasses or have not found it yet. Further, comments like
The best document about feature availability is: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96531/ch5_edit.htm#73594
> Are ROLLUP and CUBE and the advanced grouping sets functions part of the
> base SQL functionality or part of the OLAP option?
>
> How about the advanced analytics, such as SUM OVER, RANK, and the
Windowing
> functions?
In the referenced document you find that CUBE, ROLLUP and analytic functions are part of the Standard Edition as well. Therefore they should not be part of the OLAP option.
Chris
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=