roll up and cube operators in oracle

[cyno]

Hi Folks

Is there any roll up and cube operators in Oracle.Iam new to oracle.Any help would be appreciated.

cyno

 

[SantaMufasa]

Cyno,

Since terminology may differ between your familiar environments and Oracle, could you please give examples of what behavior you want Oracle to exhibit for "Rollup" and "Cube" operations?

 

[cyno]

Mufasa
I worked in sql server and iam not getting the expected
results when i use rollup operator in oracle.Here u go

select item,color,sum(qty) as quantity
from ITEMS group by item,color with rollup

can you pls help me out....


cyno

 

[SantaMufasa]

Cyno,

I apologise for my lack of intuition on your "...with rollup" example. I am not familiar enough with SQL Server to be aware of the behaviour. Could you please post a simple example of the behaviour you expect from Oracle if it were able to produce same/similar results to SQL Server?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:05 (28Mar04) UTC (aka "GMT" and "Zulu"), 23:05 (27Mar04) Mountain Time)

 

[ddrillich]

cyno,

The CUBE and ROLLUP are modifiers to the GROUP BY clause since at least Oracle 8.1.6.

Please look at:

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#83435

http://www.tek-tips.com/viewthread.cfm?SQID=739552&SPID=759&newpid=759&page=2

Regards,
Dan