Oracle MINUS Operator Explained

MINUS is an operator in Oracle database used to compare two query result sets and identify records that are present in the first result set but not in the second result set. It subtracts common records from the second result set from the first result set, returning unique remaining records.

For example:

SELECT column1 FROM table1
MINUS
SELECT column1 FROM table2;

This will return the column1 values that exist in table1 but not in table2.