Cube oracle

 -- the CUBE extension will generate subtotals for all combinations of the 
 -- dimensions specified. If "n" is the number of columns listed in the CUBE,
 -- there will be 2^n subtotal combinations.
 
 SELECT fact_1_id,
       fact_2_id,
       fact_3_id,
       SUM(sales_value) AS sales_value
FROM   dimension_tab
GROUP BY CUBE (fact_1_id, fact_2_id, fact_3_id)
ORDER BY fact_1_id, fact_2_id, fact_3_id;

Source: oracle-base.com

Similar codes

6 votes348 views1 answer
Check Table Exists
SQL
4 votes356 views3 answers
Order by value mysql
SQL
1 vote347 views1 answer
Show table status command in mysql
SQL
1 vote358 views1 answer
Python escape mysql
SQL
1 vote358 views1 answer
Convert varchar to int in sqlite
SQL
0 vote372 views1 answer
Delete * from where id = 1;
SQL
3 votes363 views1 answer
How to find names includes in sql
SQL
0 vote326 views1 answer
Update set with join pl sql
SQL
1 vote351 views1 answer
Postgresql delete cascade
SQL
0 vote356 views1 answer
Oracle list subpartitions
SQL