Re: SELECT within a DECODE alternatives??

a useable alternative would be to write a pl/sql function for it that returns you a value.
either it can return the correct value or a true or false which you can decode

Hamm wrote:

> I was browing through dejanews and found out there is no
> support for the select statement within a decode for the
> version of oracle I am using (8.0.6 I believe)
>
> The problem is I need an alternative now.
> I am working on a series of statements, with
> the core of the problem being a series of if statements
> (nested decodes), but the criteria is that a certain field
> exists in a lookup table ie. something like
>
> SELECT DECODE(SELECT FIELD FROM TABLEa A WHERE A.FIELD = 'VALUE',
> NULL,
> DECODE(..another nested decode..),
> NULL )
> FROM TABLEb
> WHERE bunch of criteria
>
> Is there an alternative for this in pure sql?
Received on Fri Jun 22 2001 - 04:29:19 CDT