Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL and boolean stuff

Re: SQL and boolean stuff

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Mon, 1 Mar 2004 09:43:58 -0500
Message-ID: <0%H0c.450$Xy3.1673@tor-nn1.netcom.ca>


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...

> 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?
Received on Mon Mar 01 2004 - 08:43:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US