This topic describes the MINUS clause.
The following statement provides the general syntax of the MINUS clause:
select_statement MINUS select_statement
select_statement
is a SELECT
statement that does not contain an ORDER BY
or FORUPDATE
clause.
The MINUS
operator computes the set of rows that are in the result of the left SELECT
statement but not in the result of the right one.
The result of the MINUS
clause does not contain duplicate rows.
Unless otherwise specified in parentheses, multiple MINUS
operators in the same SELECT
statement are evaluated from left to right. The MINUS
clause binds at the same level as the UNION
clause.