Jonathan,
On 81714 on NT4 we get the following
SQL> select * from v$version;
BANNER
--
Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
PL/SQL Release 8.1.7.1.0 - Production
CORE8.1.7.0.0 Production
TNS for 32-bit Windo
Title: RE: CASE Expressions
It must have been new with 8.1.6. I run it successfully on 8.1.6, but I get errors on 8.1.5.
--
From: MacGregor, Ian A.
To: Multiple recipients of list ORACLE-L
Subject: RE: CASE Expressions
Date: Monday, July 23, 2001 11:10AM
CASE has been around since
2 FROM dual;
YA> SELECT CASE 1 WHEN 1 THEN 2
YA> *
YA> ERROR at line 1:
YA> ORA-00923: FROM keyword not found where expected
Title: RE: CASE Expressions
Jonathan
CASE is not supp
CASE is supported in 8.1.6 and 8.1.7. Jonathan, as far as I can
tell, your SQL statement is flawed. Shouldn't it be something
like:
select case when 1=1 then 2 end as test
from dual;
Jon Walthour
>--- Original Message ---
>From: Yuval Arnon <[EMAIL PROTECTED]>
>To: Multiple recipients of li
Title: RE: CASE Expressions
Jonathan
CASE is not supported in 8.1.7.
SQL> select * from v$version;
BANNER
Oracle8i Enterprise Edition Release 8.1.7.
It's available on 816
*
--- Jonathan Gennick <[EMAIL PROTECTED]> a écrit :
> I'm doing some research for a book, and I need to
> know when
> Oracle began to support CASE expressions. I thought
> it was
> in Oracle9i, but the new features list seems to
> imply that
> CASE may have come about in 8
CASE has been around since at least 8.1.6. The syntax you posted is incorrect. I
believe you wanted something akin to the following:
1 select case
2 when 1=1 then 2
3 else 3
4 end "1"
5* from dual
SQL> /
1
-
2
Ian MacGregor
Stanford Linear Accelerator