Re: Case Statement

corvax_kg_at_my-deja.com wrote:
>
> No. CASE statement is not supported in Oracle8.
> This statement will be supported in Oracle9i. :)
> Wait for Oracle9i full release.
>
> In article <OnFYrRfRAHA.369_at_cpmsnbbsa07>,
> "Mason Liu" <masonliu_at_msn.com> wrote:
> > Does Oracle8 support the case statement in SELECT.
> >
> > For example:
> >
> > SELECT (CASE col_a WHEN 1 THEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'UNKNOWN'
 END)
> > FROM table...
> >
> > I know decode() can accomplish this, but I like to know this for
 migration
> > reasons.
> >
> > Thanks,
> >
> > Mason Liu
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Its in 8.1.6 - well at least according to the 8.1.6 doco it is.

HTH

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."