Re: Learning Oracle - ORA-00907

"Missy Pont" <missyp_at_excite.com> writes:

> SELECT (X < Y) AS X_Is_Smaller, ....
> ORA-00907: Missing right parenthesis
>
> Your time will be appreciated. Thanks.

If you're trying to implement a conditional in straight SQL(as I suspect), try:

select 'x' from dual where ( X < Y ); Received on Tue Apr 02 2002 - 00:01:24 CST