Rollup and Cube in Oracle

Question

Hi..... I want to know what is the use of rollup and cube function in oracle ? Is it possible in Sql Serever ? Please explain with an example ? Thanks......

Vineet Kumar Saini · Answer

Thanks to all.

Shankar M · Answer

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

Vulpes · Answer

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