The UNION operator combines the results of two or more SELECT queries into a single result set – as if it came from a single query. It merges the rows from different queries, removes duplicate rows, and presents a unified result.
What is the purpose of the UNION operator in Oracle SQL?
Share:
You May Also Like
Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
- Interview
- November 30, 2023
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
- Interview
- November 30, 2023
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...
- Interview
- November 30, 2023
