Re: Help with DECODE
From: rob <rob_at_dsdelft.nl>
Date: Thu, 17 Jan 2002 13:25:14 +0100
Message-ID: <a26fra$har$1_at_news.tudelft.nl>
Date: Thu, 17 Jan 2002 13:25:14 +0100
Message-ID: <a26fra$har$1_at_news.tudelft.nl>
> Unfortunately Oracle requires me to do a very convoluted/nested DECODE
> with GREATEST and LEAST functions embedded. Any help on a more simple
> way to do this is appreciated. Or, a solution as to how to make this
> work at all will be a lifesaver. Thanks in advance.
What version do you use. In oracle 8(i?) you can use the 'case' stament.
Rob Received on Thu Jan 17 2002 - 13:25:14 CET