Hmmm...I've been executing this a script in TOAD, which seems to account for some differences. The really wierd thing in TOAD is that the SELECT acually WORKS CORRECTLY if I insert a COMMENT immediately after the ANALYZE statement! Of course, comments don't make a lick of difference in this for SQL*Plus.
Wierd, wierd, wierd. Let us know what you get from your TAR! Thx! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Thanks Rich, But it does not work. One should execute with exactly same order. I you do "where f1 >= 2000 and f1 <= 2001" first, everything works fine (as expected). Here is the last part of the output SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2000; F1 ---------- 2000 SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2001; F1 ---------- 2000 SQL> select f1 from tb1 where f1 >= 2001 and f1 <= 2000; F1 ---------- 2001 SQL> drop table tb1; Table dropped. SQL> So far, works properly on 8.1.6.0.0 NT 8.1.6.0.0 32bit Solaris 9.0.1.2 Linux 9.0.1.2 AIX 9.0.1 Solaris does not work on 8.1.7.2.0 64bit HP-UX 8.1.7.2.0 32bit HP-UX 8.1.7.3 Solaris Alex. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
