Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL and boolean stuff
Yes it works great!
I didn't know it was available in 817, I tried anyway but must have made a mistake in the syntax cause it returned an error. Your example works perfectly good.
Thanks
-- 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--- "Bricklen" <bricklen-rem_at_yahoo.comz> a écrit dans le message de news:AcP%b.91491$Hy3.45087_at_edtnps89...Received on Mon Mar 01 2004 - 08:43:58 CST
> CASE works fine on 817
>
> select case when 1=0 then 'no' when 1=1 then 'yes' else 'neither' end
> from dual;
>
> Does it not work for you?