Re: How to join two tables twice
joining two tables option is there in oracle in which use code
Tropashko has a great analysis of this common SQL problem from both a mathematical perspective and a practical Oracle perspective. It also shows an undocumented technique for improving execution speed for querying the non-intersection of two tables.
Vadim notes that the _convert_set_to_join parameter can be used when comparing the contents of two tables. This type of SQL query is called a "semantic difference", or an "anti-union" operation. Tropashko depicts the table comparison problem below:
Subject
Written By
Posted
Re: How to join two tables twice
July 07, 2011 12:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.