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 vote167 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
6 votes145 views3 answers
Oracle all dates between two dates
SQL
1 vote172 views1 answer
Sqlalchemy on delete set null
SQL
2 votes133 views1 answer
Oracle cpu per session
SQL
0 vote130 views1 answer
Mysql multiple count
SQL
0 vote217 views1 answer
Sql if clause within where clause
SQL
0 vote136 views1 answer
Sql clear table
SQL
5 votes164 views1 answer
Oracle asynchronous query
SQL
0 vote149 views1 answer
Sqlite commands
SQL
0 vote261 views1 answer
How to delete duplicate rows in oracle
SQL