Re: Expression

From: damorgan <damorgan_at_exesolutions.com>
Date: Mon, 01 Apr 2002 21:36:14 GMT
Message-ID: <3CA8D2CF.3EFFC6A1@exesolutions.com>

Oracle is not a Microsoft product. True and False are Boolean ... numbers. The SQL statement you included, in Oracle, is complete uncompilable nonsense.

If you wish to work in Oracle forget what you learned in that other product, likely Access, and learn Oracle. Otherwise you are wasting your time and will just end up frustrated, angry, and blaming Oracle for your own mistakes.

Daniel Morgan

Howard McFarland wrote:

> In Oracle 8i, if the below statement is true, it gives 1 or -1?
>
> (A > B)
>
> It gives -1 in a DBMS that I used to use.
>
> Also, is below a valid SQL statement in Oracle?
>
> SELECT (A > B) AS True .....
>
> Thanks.
Received on Mon Apr 01 2002 - 15:36:14 CST