Yes, in SQL but not PL/SQL (so far as I understand).
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3ce10350$0$8508$ed9e5944_at_reading.news.pipex.net...
> 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 - 09:29:19 CDT
