RE: Decode function
- From: "SHEEHAN, JEREMY" <Jeremy.Sheehan@xxxxxxx>
- To: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Jul 2009 16:36:23 -0400
That solves my problem! Thanks!!
Jeremy
P Consider the environment. Please don't print this e-mail unless you really
need to.
From: Bellows, Bambi (Comsys) [mailto:bbel5@xxxxxxxxxxxx]
Sent: 29 July, 2009 4:34 PM
To: SHEEHAN, JEREMY; Oracle L
Subject: RE: Decode function
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?
TIA!!
Jeremy
P Consider the environment. Please don't print this e-mail unless you really
need to.
Other related posts:
