No, Oracle 7 does not support the case statement. See decode. Or upgrade
to a supported version.
Jim
"Matteo Gabella" <gabu2000_at_tin.it> wrote in message
news:bda2e795.0205140337.25b89f1e_at_posting.google.com...
> does oracle 7 support this statement SQL ?
>
> SELECT T1.name,
> CASE when T1.sex = 'M' then 'Male'
> when T1.sex = 'F' then 'Female'
> ELSE 'Unknown'
> end as "gender"
> FROM pers T1
>
> i don't know if CASE statement is supported by ANSI-92, while Oracle 7
> support - i think - ANSI-92
>
> thanx
> m.
Received on Tue May 14 2002 - 07:17:36 CDT
