does 817 support CASE? I thought that this was 9i and up.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:Af7E8.47455$RR3.77597_at_sccrnsc02...
> 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:30:08 CDT
