Actually - union all is Probably the choice if you create e view an access it as a "shielded" user though BO-reports.
BUT
This has nothing to do with Oracle specifically.
A _union_ gives all the _distinct_ values from the two tables
A _union_all_ gives all values from the two...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.