The SQL set operators now support all keywords as defined in ANSI SQL. The new operator
EXCEPT [ALL] is functionally equivalent to
MINUS [ALL]. The operators
INTERSECT now support the keyword
Full ANSI compliance provides greater compatibility with other database vendors and makes migration to Oracle Database easier than before.
This page provides more detailed information about the new SQL set operator and the enhanced existing ones.
This practice shows how to use the new set operators,
EXCEPT ALL and