Operators

• new operators

• existing operators with changes in functionality

New Operators

SOME

This new comparison operator is synonymous with the ANY comparison operator.

UNION ALL

This new set operator combines two queries and returns all rows returned by either query, including all duplicate rows. The UNION ALL operator is similar to the UNION operator, except the UNION operator returns only one copy of duplicate rows.

Existing Operators with Functional Changes

-

Do not use consecutive minus signs with no separation in arithmetic expressions to indicate double negation or the subtraction of a negative value. The characters -- are used to begin comments within SQL statements. If you have applications that issue SQL statements with such arithmetic expressions, separate the minus signs with a space or a parenthesis.

LIKE

The LIKE operator accepts the new ESCAPE option, which allows you to use the characters % and _ literally, rather than as special pattern matching characters, within a pattern.

(+)

The outer join operator is subject to new restrictions listed in the section describing the SELECT command earlier in this chapter.