Question: what is the difference between union and intersect in oracle?
Answer: The difference between UNION and INTERSECT is that UNION gets results from both queries and combines them, while INTERSECT gets results that only exist in both queries.