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 vote319 views1 answer
Ilike for date postgres
SQL
0 vote356 views1 answer
Delete record by id sql
SQL
3 votes314 views1 answer
Oracle apex message quit website
SQL
1 vote342 views1 answer
Postgresql create table with timestamp
SQL
0 vote319 views1 answer
Duplicate value unique constraint mysql error
SQL
-1 vote365 views2 answers
Import data from excel to sql server automatically
SQL
0 vote341 views1 answer
Bidirectional outer join sql
SQL
0 vote307 views1 answer
Time in sql server
SQL
0 vote339 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote327 views1 answer
Get the Db column names from a SqlDataReader
SQL