Enhanced SQL Set Operators

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 MINUS and INTERSECT now support the keyword ALL.

Full ANSI compliance provides greater compatibility with other database vendors and makes migration to Oracle Database easier than before.

Details: Enhanced SQL Set Operators

This page provides more detailed information about the new SQL set operator and the enhanced existing ones.

Practice: Using New Set Operators

This practice shows how to use the new set operators, EXCEPT, EXCEPT ALL and INTERSECT ALL.

Related Topics