Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select * from viewname where 1<>1 gives records back

954793Aug 9 2012 — edited Aug 13 2012
for one customer the following sql gives records back
select * from viewname where 1&lt;&gt;1

we asked the customer to send over the database to us but we can't reproduce this behaviour. We don't get any records. the problem is we don't have the same version of oracle they use 9.2.0.4 and we used 10.2.0.1. i can't download the 9i version anymore.

Does anybody know of a bug in oracle which can cause such behaviour or a setting which can correct this?

Edited by: BluShadow on 09-Aug-2012 10:06
corrected the &lt;&gt; issue so it's visible. Please read {message:id=9360002} which describes this issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2012
Added on Aug 9 2012
7 comments
192 views