How does Oracle find the intersection?

In Oracle database, you can use the built-in INTERSECT keyword to find the intersection of two query result sets. The usage of the INTERSECT keyword is as follows:

SELECT column1, column2, ...
FROM table1
INTERSECT
SELECT column1, column2, ...
FROM table2;

This will return the intersection of two query result sets, which are the data rows that exist in both table1 and table2 simultaneously. It is important to note that the INTERSECT keyword automatically removes duplicate data rows.