MINUS Operator In Oracle

MINUS returns all the distinct rows from first select statement which are not present in second select statement.

Below is the graphical representation of MINUS operator.

CREATE TABLE EMPLOYEES_MINUS_30
AS
SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE, 

INTERSECT Operator In Oracle

INTERSECT operators returns the distinct common rows from each query.

Below is the graphical representation of INTERSECT operator.

CREATE TABLE EMPLOYEES_INTERSECT_30
AS
SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE, JOB_ID, SALARY, 

Oracle SET Operators

Oracle SET operators combine two or more queries and return single set of result.

Types of SET operators: