---

Oracle INTERSECT Operator

In Oracle, the INTERSECT operator takes the results of two queries and returns only rows that appear in both result sets. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results.

Oracle INTERSECT OPERATOR Syntax

To fetch the results of two queries and returns only rows that appear in both result sets, use the following syntax:

Parameters:

tablename1 & 2: The table name from which you want to achive INTERSECT operator.

.

Oracle INTERSECT OPERATOR example with Single Field

The following Oracle example is using INTERSECT to perform retrive data from both the tables:

Note:

In the above example, if "firstName" appeared in both the tblcustomer and tblcustomerloan table, it would appear in your result set.

---

---