RE: Decode function

  • From: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
  • To: <Jeremy.Sheehan@xxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Jul 2009 15:34:08 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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?





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

Other related posts: