Re: Unexpected result from simple query

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 12 Dec 2003 08:48:45 -0600
Message-ID: <a8ljtv4k7c2o4tie1lcij9qhts9kehmf6f@4ax.com>

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

---

Received on Fri Dec 12 2003 - 08:48:45 CST