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

1 vote146 views1 answer
Mysql return if it contains
SQL
0 vote147 views1 answer
Check if has alpha characters sql
SQL
0 vote133 views1 answer
Mysql find missing values
SQL
0 vote145 views1 answer
Postgresql not in alternative
SQL
3 votes136 views1 answer
DB: in eloquent using sql
SQL
23 votes131 views6 answers
How to create table in sql
SQL
0 vote147 views1 answer
New rails app with mysql
SQL
0 vote145 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote193 views1 answer
Drop view sql
SQL
0 vote191 views3 answers
Select top 10 rows in sql
SQL