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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

Re: PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

From: internetmaster <youlove_at_me.com>
Date: Tue, 30 Jul 2002 19:15:29 -0400
Message-ID: <3D471E11.2070106@me.com>


I don't think PL/SQL shares the same SQL engine in 8.1.7. I think it does in 9i, however.

FC wrote:
> Hello,
> did anybody come across the following on Win2K Ora 8.1.7.0.0 EE?
>
> While I am allowed to use the CASE WHEN ELSE END construct within ordinary
> SQL, I cannot use it within PL/SQL modules (syntax error occurs). On the
> other hand I can use the DECODE function, although it's harder to code in
> certain cases.
> I couldn't find any document stating that PL/SQL does not support this
> feature.
>
> Bye...
> Flavio
>
>
Received on Tue Jul 30 2002 - 18:15:29 CDT

Original text of this message

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