Re: case when ... then expression

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 26 Jun 2001 22:41:16 +0100
Message-ID: <9havgn$6i7$1@news.chatlink.com>

decode(sign (x-y),1,"x is more than y","x is less than or equal to y")

hth

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

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
"rob" <rob_at_dsdelft.nl> wrote in message news:9h9kal$lq9$1_at_news.tudelft.nl...


>

> > > Second it's a pain in the backside using

> > > decode() with range tests, as required by

> > > the original post.

> >

> > You're right. Really painful to type <=.

>

> I'm confused. How would you use <= in a decode statement?

>

> Rob.

>

>

Received on Tue Jun 26 2001 - 16:41:16 CDT