I should say for version 817 only, as CASE would take care of it in 9i.
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Syltrem" <syltremzulu_at_videotron.ca> a écrit dans le message de
news:mlO%b.357$Xy3.1178_at_tor-nn1.netcom.ca...
> 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 +
>
> --
> Syltrem
>
> OpenVMS 7.3-1 + Oracle 8.1.7.4
> http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
> ---zulu is not in my email address---
>
>
Received on Fri Feb 27 2004 - 15:11:59 CST
