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

0 vote172 views1 answer
Sql server isnull function nor working count
SQL
0 vote186 views1 answer
How to check foreign key constraint in sql
SQL
0 vote168 views1 answer
Except in sql alchemy
SQL
5 votes214 views2 answers
Add days in oracle sql
SQL
4 votes146 views1 answer
Oracle show errors compilation
SQL
15 votes165 views4 answers
Pl sql
SQL
0 vote154 views1 answer
Use between operator in mysql
SQL
0 vote176 views1 answer
How to define a non primary composite key in sql
SQL
0 vote180 views1 answer
How to combine rows in sql server procedure
SQL
0 vote153 views1 answer
Mysql export search results
SQL