Re: Is ROLLUP functionality part of baseline?

Hans, from what I gather, the analytics functions are part of 9i SE and EE (even WITHOUT the OLAP option).

AskTom had a lot of people asking this as well. ;o)

http://asktom.oracle.com/pls/ask/f?p=4950:8:15295130417236508718::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1941199930674,

http://asktom.oracle.com/pls/ask/f?p=4950:8:15295130417236508718::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6600385245827,

Cheers.

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
Received on Wed Jun 30 2004 - 07:42:25 CDT