SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternate for union all Query.

User_JL3CWAug 31 2022

Hi All,

I have a report of 90 oracle sql queries. There are aggregations to be done using these 90 queries. Some aggregations has 60 queries to be included. I have performed aggregations using union all.
Please let me know any other approach or process to perform these aggregations (summary).

Regards,
CK

Added on Aug 31 2022

7 comments

449 views

1 mention