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

5 votes157 views4 answers
Upload database mysql command line
SQL
1 vote305 views3 answers
Sql subquery
SQL
2 votes157 views1 answer
Mysql id of inserted row
SQL
1 vote137 views1 answer
Oracle aleter trigger ora-01031
SQL
2 votes145 views1 answer
Alter table add column and foreign key mysql
SQL
3 votes153 views3 answers
Stop mysql ubuntu
SQL
24 votes142 views4 answers
How to add column sql
SQL
0 vote146 views1 answer
Oracle archivelog usage
SQL
0 vote146 views1 answer
Add multiple field in table sql
SQL
4 votes196 views4 answers
Remove duplicate old value in mysql
SQL