Rollup and Cube in Oracle

Thanks to all.

0

Hi User,

Hope the below link will help you..

RollUp and Rollup by cube are used to get the aggregrate and sub-totals in oracle sql,.

http://www.oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets.php

Thanks,
Shankar

0

Vulpes14y ago

As it's difficult to explain what these functions do in a few words, I'd check this link for Oracle:

http://www.remote-dba.net/pl_sql/t_analytic_functions_oracle_rollup_cube.htm

and these for SQL Server 2005 :

http://msdn.microsoft.com/en-us/library/ms189305(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms175939(SQL.90).aspx

0