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

31 votes285 views2 answers
Grant all priviledges to mysql user
SQL
1 vote280 views3 answers
Epoch to datetime
SQL
0 vote256 views1 answer
How to get inserted id in sql server
SQL
0 vote259 views1 answer
Oracle archivemode
SQL
0 vote278 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote254 views1 answer
How to to get current date and time in sql
SQL
1 vote259 views2 answers
Mysql does sentance contain word
SQL
13 votes286 views6 answers
Mysql remove duplicates
SQL
0 vote264 views1 answer
Sql revert migration
SQL
8 votes289 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL