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 vote274 views1 answer
Object Information
SQL
3 votes263 views4 answers
Show sql server database
SQL
2 votes245 views1 answer
Mysql admin u root p password change password
SQL
6 votes325 views2 answers
Mysql convert timestamp to date
SQL
1 vote282 views1 answer
Oracle split string
SQL
0 vote284 views1 answer
Sqlite commands
SQL
0 vote285 views1 answer
Php get closest location by latitude longitude
SQL
3 votes300 views2 answers
Sql server current date without time
SQL
0 vote286 views1 answer
Plsql check for string in numeric
SQL
0 vote299 views1 answer
Mysql add text to existing field
SQL