Question: what is the difference between cube and rollup operators in oracle?
Answer: ROLLUP operator generates aggregated results for the selected columns in a hierarchical way. On the other hand, CUBE generates a aggregated result that contains all the possible combinations for the selected columns. Here data is aggregated in hierarchical manner.