Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!feeder.qis.net!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: dennishancy@eaton.com (Dennis Hancy)
Newsgroups: comp.databases.oracle.misc
Subject: Decode Statement
Date: 10 Oct 2001 12:01:44 -0700
Organization: http://groups.google.com/
Lines: 16
Message-ID: <248587ca.0110101101.3bf63714@posting.google.com>
NNTP-Posting-Host: 63.65.244.200
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002740504 12033 127.0.0.1 (10 Oct 2001 19:01:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 19:01:44 GMT
Xref: easynews comp.databases.oracle.misc:70142
X-Received-Date: Wed, 10 Oct 2001 12:01:28 MST (news.easynews.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