My Oracle Support Banner

Inconsistent Output When Conditions in WHERE Clause Switched (Doc ID 265214.1)

Last updated on NOVEMBER 12, 2019

Applies to:

SQL*Plus - Version to [Release 8.1.7 to 9.2]
Information in this document applies to any platform.
This problem can occur on any platform.


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 <>


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.