...

Database Managment - Oracle

Back to Course

Lesson Description


Lession - #1439 Oracle INTERSECT Operator


Oracle INTERSECT Operator

In Oracle, INTERSECT Operator is utilized to return the aftereffects of at least 2 SELECT proclamation. It picks the normal or crossing records from compound SELECT inquiries.

Syntax

SELECT expression1, expression2, ... expression_n  
FROM table1  
WHERE conditions  
INTERSECT  
SELECT expression1, expression2, ... expression_n  
FROM table2  
WHERE conditions;