Cube « Analytical Functions « Oracle PL / SQL

  1. Oracle PL / SQL
  2. Analytical Functions
  3. Cube




1.Cube implies reducing tables by rolling up different columns (dimensions)
2.Grouping with Cube
3.CUBE clause: return rows containing a subtotal for all combinations of columns included in the CUBE clause along with a total
4.The sequence of the columns passed into Cube function
5.Use CUBE and RANK() to get all rankings of sales by product type ID and employee ID
6.Demonstrate Partial CUBE operation
7.use GROUPING SETS to produce just a subset of CUBE
8.Count employees, group by CUBE(department no, job title)
9.group by CUBE(department no, job title)





10.group by cube