RE: Decode function

From: Bellows, Bambi (Comsys) <"Bellows,>
Date: Wed, 29 Jul 2009 15:34:08 -0500
Message-ID: <AD0CB572A820AB4E8E52ABD38950FD3606AEAB6B_at_a0001-xpo0150-s.hodc.ad.allstate.com>

Not as such, but I do this all the time by use of the sign function.  

For example, if you want to return X if val> 100, Y if it's less, and Z if it's equal , you can do:  

select decode(sign(val-100),-1,'X',1,'Y',0,'Z','error') from dual;  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY Sent: Wednesday, July 29, 2009 3:29 PM
To: Oracle L
Subject: Decode function  

I think the answer is no, but can you set greater than, less than conditions in a decode function?  

TIA!!   Jeremy

P Consider the environment. Please don't print this e-mail unless you really need to.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 29 2009 - 15:34:08 CDT