Oracle MINUS Function Guide

The MINUS function in Oracle is used to subtract results from the first query from results of the second query, returning all rows that belong to the first query but not the second. The syntax is as follows:

SELECT column1, column2, ...
FROM table1
MINUS
SELECT column1, column2, ...
FROM table2;

This will return the rows selected from table1 that are not selected in table2. This is very useful when comparing two query results and finding the differences between them. The MINUS function requires that the two query results have the same number of columns and column types.