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 vote344 views1 answer
Alternative for LIMIT sql
SQL
1 vote289 views1 answer
Oracle apex run 404
SQL
4 votes304 views4 answers
Pl sql output
SQL
0 vote293 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote303 views1 answer
Mysql root permission denied lost
SQL
0 vote325 views1 answer
Python mysql show databases
SQL
14 votes309 views5 answers
Sql oracle limit
SQL
3 votes308 views1 answer
Oracle list user grants
SQL
11 votes288 views2 answers
Oracle all source
SQL
1 vote298 views1 answer
Launch sql script from docker in mysql
SQL