Re: reverse decode?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 11 May 2001 06:58:30 -0700
Message-ID: <3AFBF006.C2215BE1@exesolutions.com>

C Chang wrote:

> Is there something like reverse-decode function in side SQL or PL/SQL?
> After I use the decode to get the distinct data, I want to reverse it to
> find out what is the original data is. Thanks ahead.
>
> CC

On its face ... that is impossible for any language to do: Unless you want to write a bunch of "IF" statements.

The solution to what you suggest is to forget DECODE and just build a translation table.

Daniel A. Morgan Received on Fri May 11 2001 - 08:58:30 CDT