Re: explain a sql statement

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Sat, 26 Jan 2002 10:49:38 GMT
Message-ID: <3c528950.3023183@news.freeler.nl>

Without further specification bind variables are assumed to be of charactertype. Substitute :b1 with to_date(:b1).

Jaap.

On Fri, 25 Jan 2002 20:34:28 GMT,
u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote:

>I can not explain the following sql statement.
>SQL> create table test (start_time date,end_time date);
>Table created.
>
>SQL> explain plan for
> 2 select (end_time - :b1) * 60*24 minutes_remaining
> 3 from test
> 4 where start_time < :b1
> 5 and end_time > :b1;
>select (end_time - :b1) * 60*24 minutes_remaining
> *
>ERROR at line 2:
>ORA-00932: inconsistent datatypes
>
Received on Sat Jan 26 2002 - 04:49:38 CST