Re: DECODE or else, a little test...

Jared Still wrote:
>
> On Wed, 13 Nov 1996, Sridhar Subramaniam wrote:
>
> > L. Tseng wrote:
> > >
> > > DECODE() is probably the most powerful function in Oracle.
> > >
> > > For example
> > >
> > >
> > > IF colA = 1 AND colB = 1 THEN 'YES'
> > > ELSE 'NO'
> > >
> > > can be converted as
> > >
> > > DECODE(colA, 1, DECODE(colB, 1, 'YES', 'NO'), 'NO')
> > >
> > > BUT.....
> > >
> > > Can DECODE do the following?
> > >
> > > IF colA > 100 THEN 'A'
> > > ELSIF colA = 100 THEN 'B'
> > > ELSE 'C'
> > >
> > > Thanks,
> > >
> > > Leslie
> > >
> > Leslie,
> >
> > try decode( sign( colA - 100 ), 1, 'A', 0, 'B' ).
> > --
> >
>
> Check out the comprehensive article on this in OTJ.
> ( Oracle Tech Journal )
>
> Jared Still
> DBA/SysAdmin
> ValueRx
> jared_at_psnw.com
> stillj_at_valuerx.com

You can use the second decode function. it works fine.

-- 
    AMARENDRA B NETTEM
    ORACLE CONSULTANT
    WHITTMAN-HART CORPORATION, CHICAGO
    (http://www.iit.edu/~nettama)