Inconsistent Output When Conditions in WHERE Clause Switched
(Doc ID 265214.1)
Last updated on NOVEMBER 12, 2019
Applies to:
SQL*Plus - Version 8.1.7.0 to 9.2.0.1 [Release 8.1.7 to 9.2]Information in this document applies to any platform.
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 <
following 2 queries may give an error while the other may return some records:
select * from <
select * from <
Cause
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
Symptoms |
Cause |
Solution |