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 vote379 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote327 views2 answers
How to find max and min salary in sql
SQL
0 vote338 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote373 views1 answer
What is SQL data store?
SQL
0 vote336 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote324 views1 answer
Call function in query sql server
SQL
0 vote363 views2 answers
Sql stored procedure for access frontend
SQL
0 vote328 views1 answer
Mysql jdbc timezone
SQL
4 votes326 views3 answers
Mysql varchar length
SQL
2 votes361 views1 answer
Oracle list duplicates
SQL