Re: Please HELP... with ROLLUP (?!?!?!)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 May 2001 15:35:41 +0200
Message-ID: <th4ktchauuscf8@beta-news.demon.nl>

"Cyb3rPunk" <a.merola_at_inwind.it> wrote in message news:9ethc1$4vm$1_at_fe1.cs.interbusiness.it...
> Hi,
>
> I am migrating a web application from Microsoft SQL Server to Oracle 8.
>
> At the end of a query I found the instruction WITH ROLLUP.
>
> "The ROLLUP operator is useful in generating reports that contain
subtotals
> and totals. The ROLLUP operator generates a result set that is similar to
> the result sets generated by the CUBE operator."
>
> Is there something similar on Oracle???
>
> Please help me! :-)
>
> Alex
>
>

Has been implemented in 8.1.6. Refer to rollup in your sql reference manual, and further details in the Oracle Datawarehousing manual. The book of Jonathan Lewis also discusses this. The new operators have been implemented in the Enterprise edition only though.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon May 28 2001 - 08:35:41 CDT