REPOST: Help: Explain plan problem

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Sat, 26 Jan 2002 13:18:25 GMT
Message-ID: <5$--$%%%_$_%__-$-$@news.noc.cabal.int>

I have a table test
SQL> desc test

 Name                      Type
 --------------- ----------------------------
 START_TIME                DATE
 END_TIME                  DATE

SQL> explain plan for
  2 select (end_time - :b1)*60*24
  3 from test
  4 where end_time < :b1
  5 and start_time > :b1;
select (end_time - :b1)*60*24

ERROR at line 2:
ORA-00932: inconsistent datatypes

but if I remove *60*24, I can explain it. 1 explain plan for
  2 select (end_time - :b1)
  3 from test
  4 where end_time < :b1
  5* and start_time > :b1
SQL> / Explained.

But the first statement does not seem to use the same plan as the second one, instead, the first statement use a much more expensive one, why?

The second question, for the 1st statement, if oracle can not explain it, why oracle can execute it without giving error message?

Thanks for you help.

-- 
Sent by  dbadba62  from hotmail  within field com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

========= WAS CANCELLED BY =======:
From: u518615722_at_spawnkill.ip-mobilphone.net  (Mike F)
Control: cancel <l.1012051105.1249572753_at_pool-151-197-235-121.phil.east.verizon.net>
Subject: cmsg cancel <l.1012051105.1249572753_at_pool-151-197-235-121.phil.east.verizon.net>
Date: Mon, 28 Jan 2002 00:31:11 GMT
Message-ID: <cancel.l.1012051105.1249572753_at_pool-151-197-235-121.phil.east.verizon.net>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1         
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.hanau.net!fr.clara.net!heighliner.fr.clara.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40716133

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

Received on Sat Jan 26 2002 - 07:18:25 CST