Re: decode(sth,sth>3,null,sth)-does anybody try ...

Anywhere ... in any statement: In SQL*Plus, in procs, packages, functions, triggers, views, materialized views, did I miss anything? <g> Certainly anywhere you could use DECODE, or UPPER, or COUNT(*).

And I agree with you ... it is a very valuable tool we can apply to problem solving.

Daniel Morgan

stinky wrote:

> damorgan wrote:
>
> > Yes. The function that works like this is CASE. In 8i you can use it at
> > the SQL*Plus prompt, in views, and through Native Dynamic SQL. In 9i you
> > can use it anywhere.
>
> What other areas can you use it in 9i? I love the CASE expression. It is
> a piece of wonder code.
>
> >
> >
> > Daniel Morgan
> >
> > mariusz wrote:
> >
> > > Hi,
> > > decode(sth,sth>3,null,sth)-does anybody try anything like this?
> > > Is there any others easy whay to code like that?
> > > Thanks
Received on Thu Mar 28 2002 - 22:15:31 CET