In Oracle, INTERSECT Operator is used to return the results of 2 or more SELECT statement. It picks the common or intersecting records from compound SELECT queries.
Syntax
SELECT expression1, expression2, ... expression_n FROM table1 WHERE conditions INTERSECT SELECT expression1, expression2, ... expression_n FROM table2 WHERE conditions;
Parameters
1) expression1, expression2, ... expression_n: It specifies the columns that you want to retrieve.
2) table1, table2: It specifies the tables that you want to retrieve records from.
3) conditions: it specifies the conditions that must be fulfilled for the records to be selected.