Re: Expression

How about the fact that True is a reserved word?

If your DBA will allow it, try the following:

SELECT *
FROM V$RESERVED_WORDS; Daniel Morgan

Howard McFarland wrote:

> 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 - 17:25:43 CST