Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> wrong result from select
Hi,
Can anybody try this on 9i?
set echo on
alter session set optimizer_mode=choose;
alter session set cursor_sharing=force;
create table tb1 (f1 number(4));
insert into tb1 values (1999); insert into tb1 values (2000); insert into tb1 values (2001); insert into tb1 values (2002);
select f1 from tb1 where f1 between 2000 and 2000; select f1 from tb1 where f1 between 2000 and 2001; select f1 from tb1 where f1 between 2001 and 2000;drop table tb1;
Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0:
SQL> select * from tb1;
F1
TIA
Alex.
PS. What about cursor_sharing=similar ?
Received on Fri Feb 08 2002 - 16:59:25 CST
![]() |
![]() |