Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression
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 - 16:55:34 CDT
![]() |
![]() |