Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Decode Statement

Decode Statement

From: Dennis Hancy <dennishancy_at_eaton.com>
Date: 10 Oct 2001 12:01:44 -0700
Message-ID: <248587ca.0110101101.3bf63714@posting.google.com> 





A typical Decode statement looks like this..



decode(value, if1, then1, if2, then2...)




Can the "if" values be replaced with a range?  For instance, what if
you wanted to check if "value" is between 1 and 10.



Could you do this...



decode(value, between 1 and 10, then1, if2, then2...)   ?




Dennis Hancy


Eaton Corporation


Cleveland, OH
Received on Wed Oct 10 2001 - 14:01:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US