Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Expression

Re: Expression

From: Howard McFarland <hhmcfar_at_hotmail.com>
Date: Mon, 1 Apr 2002 16:53:22 -0500
Message-ID: <a8ajsp$kp6$1@slb3.atl.mindspring.net>


It gives:
(A > B) AS True

     *
ORA-00907: SQL missing right parenthesis

What's wrong? Thanks in advance.

"Howard McFarland" <hhmcfar_at_hotmail.com> wrote in message news:a8aj9h$4np$1_at_slb2.atl.mindspring.net...
> 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:53:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US