Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unexpected result from simple query
Turkbear wrote:
> "Can" <no_at_spam.net> wrote:
>
>
>>>PS. In case you don't get - Oracle version and platform are two >>>critical pieces of data that *always* must accompany a question like >>>yours. >> >>Ooops, Windows XP ist the platform and I'm using version 9.2.0.1 ;) >>
That's a patched version of the OP's version. Which *may* explain the difference.
I still have problems with ANSI joins in a sub select on 9.2.0.4; the select works, using the ANSI joins, but a select 1 from dual where (...) does not. (...) being the very same select. Other join problems have gone since patching from 9.2.0.3 to 9.2.0.4
-- Regards, Frank van BortelReceived on Sat Dec 13 2003 - 08:57:15 CST
![]() |
![]() |