Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Expression
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