KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have two selects and I want to combine them in such a way, that only rows unique in both selects are returned. Is there any built-in way in Oracle 10g to achieve this? I know I can do something like this: (select1 UNION select2) MINUS (select1 INTERSECT select2) but I would like to avoid it. Both select1 and select2 have 20 lines, so this way would be really obscure and difficult to maintain.
Tags (comma-separated)
Save Edits
Cancel