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 vote137 views1 answer
Kill a pid redshift
SQL
0 vote122 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote138 views1 answer
Pagination with row_number
SQL
6 votes148 views4 answers
Mysql group by month
SQL
1 vote149 views1 answer
Sql server: query to find out all the places where the table is used
SQL
3 votes133 views1 answer
Sql replace character in string in all records
SQL
0 vote155 views1 answer
Full outer join in mariadb mysql
SQL
5 votes136 views1 answer
Oracle sysdate
SQL
5 votes129 views1 answer
Oracle get nls settings
SQL
0 vote101 views1 answer
Expose db in virtualbox
SQL