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 vote139 views1 answer
The local psql command could not be located
SQL
2 votes166 views3 answers
Sql interview query questions
SQL
0 vote144 views1 answer
How to count null values in sql
SQL
0 vote149 views1 answer
Addition of 2 column value in mysql
SQL
1 vote176 views2 answers
One to one and one to many relationship
SQL
3 votes153 views1 answer
Oracle list invalid password ORA-01017
SQL
2 votes153 views1 answer
Sqlite indexes
SQL
0 vote153 views1 answer
Inserted row count tsql
SQL
0 vote161 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote143 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL