Is there any function available like UNION to do intersection of two resultsets in oracle?
Thanks in advance.
BI DWH BALA
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Christian13467 · Dec 04, 2009 at 05:56 AM
There are UNION, UNION ALL, MINUS and INTERSECT.
Answer by HillbillyToad · Dec 03, 2009 at 11:12 PM
You mean like UNION? http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/TSQ41B/Default.aspx
Answers Answers and Comments
No one has followed this question yet.
What is Pragma Init Exception in oracle?
Archive log over 300GB DB never backed up
Difference between NOT IN and NOT EXISTS?
get field x in database with sql query
schema trigger with long datatype?