Syltrem wrote:
> Hi
>
> Is it possible to do something like this:
>
> select decode(1=1, true, 'true', 'false') from dual;
>
> instead of 1=1, in real life I would do something like "colum1 < 10" or
> "column2 > 'G'", for example
>
> I don't want to have to write a function, etc.
> I just want to know if getting a true or false boolean value is possible
>
> Thanks for suggestions
> Oracle 817 or +
>
Why not use a CASE statement?
select case when col1 < 10 or col2 > 'G' then <do something>
else <do something else> end
from dual;
Received on Fri Feb 27 2004 - 15:12:59 CST
