Inconsistent Output When Conditions in WHERE Clause Switched

(Doc ID 265214.1)

Last updated on OCTOBER 28, 2016

Applies to:

SQL*Plus - Version: 8.1.7 to 9.2
This problem can occur on any platform.

Symptoms

The execution of SQL query may throw errors if the conditions specified under
the WHERE clause are switched. If there are 3 conditions such as
WHERE <> AND <> AND <> then the output of one of the
following 2 queries may give an error while the other may return some records:

select * from <> WHERE <> AND <> AND <>

select * from <> WHERE <> AND <> and <>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms