Re: Learning Oracle

From: H. ROMDHANE Mohamed <romdane_at_noos.fr>
Date: Sun, 7 Apr 2002 21:12:03 +0200
Message-ID: <3cb09812$0$5346$79c14f64@nan-newsreader-03.noos.net>

You want perhaps test X :: Y ?

You may try the LEAST or the GREATEST functions

SELECT LEAST (X, Y) Smallest
FROM ... PS: There's no boolean type in SQL as in PL/SQL ! "Missy Pont" <missyp_at_excite.com> a écrit dans le message de news: a8bejg$fb1$1_at_slb3.atl.mindspring.net...
>
> SELECT (X < Y) AS X_Is_Smaller, ....
> ORA-00907: Missing right parenthesis
>
> Your time will be appreciated. Thanks.
>
>
>
Received on Sun Apr 07 2002 - 14:12:03 CDT

Re: Learning Oracle - ORA-00907