Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unexpected result from simple query

Re: Unexpected result from simple query

From: Frank <fbortel_at_nescape.net>
Date: Sat, 13 Dec 2003 15:57:15 +0100
Message-ID: <brf8rl$6pj$1@news2.tilbu1.nb.home.nl>


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

>
>
> XP and 9.2 works for me:
> ---------------------------------------------------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
> PL/SQL Release 9.2.0.2.1 - Production
> CORE 9.2.0.2.0 Production
> TNS for 32-bit Windows: Version 9.2.0.2.0 - Production
> NLSRTL Version 9.2.0.2.0 - Production
>
> SQL> select emplid,deptid from
> 2 (select emplid,deptid,rownum rn from rca_employee_timesheets)
> 3 where rn between 4 and 12;
>
> EMPLID DEPTID
> ----------- ----------
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
> 00001018 T796320
>
> 9 rows selected.
>
> SQL>
> --------------------------------------------------------------------------------------------------

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 Bortel
Received on Sat Dec 13 2003 - 08:57:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US