Re: CUBE operator??

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 3 Jan 1999 19:40:22 -0500
Message-ID: <jVyj2.188$24.658@news.ipass.net>

Hi Jimmy:

Oracle8.1 (ie. Oracle8i) has a CUBE operator and a ROLLUP operator that is part of the GROUP BY clause. ROLLUP returns summarized rows plus subtotals of summarized rows. CUBE returns rows as cross-tabbed results. I don't know about SQLServer.

Also, in any version of Oracle you can *fake* cross-tabbing by using the DECODE function, but it can get a little ugly, although the values are, of course, correct.

Hope this helps.

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Jimmy wrote in message <368C746E.7082_at_comp.polyu.edu.hk>...
>Hello all,
> I heard that SQL Server 7.0 can use CUBE operator (data warehouse
>operator). Is that right? And how about Oracle? Or Oracle support
>something like CUBE operator in data warehousing?
>
>Thanks,
>Jimmy
Received on Sun Jan 03 1999 - 18:40:22 CST