Re: Is ROLLUP functionality part of baseline?

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<AGsEc.55196$HS3.45437_at_edtnps84>...
> 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?
>
> 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
>
> "Oracle9i's new SQL aggregation features of grouping sets, concatenated
> grouping sets and composite columns provide high efficiency aggregations
> for the full range of business intelligence tasks. Oracle products such as
> the Oracle9i OLAP option are already taking advantage of the features"
>
> found at http://otn.oracle.com/products/oracle9i/daily/feb01.html are
> leaving me even more confused than usual.
>
> Pointers/links to official answers most appreciated.
> /Hans

I believe that the analytic queries are part of the baseline Enterprise Edition installation, but I am not sure where to find this information in the documentation.

Just tagging along for other responses.
-- Mark D Powell -- Received on Wed Jun 30 2004 - 08:58:17 CDT