Re: PL/SQL - DECODE

You can still select decode(..) into (...) from dual if you prefer.

HTH, Yosi

Kenneth C Stahl wrote:

> Use an if..then..else construct. decode() is an oracle-specific non-ansi
> extension to sql. The fact that pl/sql has some functions which work
> exactly the same as sql functions is, to some extent, coincidental.
> Oracle decided not to implement decode() in pl/sql and as a result it is
> not available.
>
> Nandakumar wrote:
>
> > Hi
> >
> > What is the equivalent of decode (of SQL) in PL/SQL?
> > Any SWITCH/WHEN/CASE are available in PL?SQL???
> >
> > It appears like DECODE not allowes in PL/SQL!!
> > PLS-00204: function or pseudo-column 'DECODE' may be used inside
> > a SQL statement only
> > --
> > Nandakumar
> > Systems Analyst
> > New York
> > (N.Kumar_at_rocketmail.com)
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 15:42:57 CDT