- ========== Old Style (SQL*Plus Release < 8.1.6.0.0) =========
SQL> select decode(ename,'SCOTT','IIII','CCCC') as test,
2 ename from emp;
TEST ENAME
---- ----------
CCCC SMITH
IIII SCOTT
- ========== New Style (SQL*Plus Release >= 8.1.6.0.0) =========
SQL> select (case when ename='SCOTT' then 'IIII' else 'CCCC' end) test, ename
2 from emp;
TEST ENAME
---- ----------
CCCC SMITH
IIII SCOTT
AlexNet: http://www.apro.fr/ or http://www.best-of.net/
"Olivier Villeneuve" <olivier.villeneuve_at_fra.sas.com> a écrit dans le message news:
8ts7lq$aqh$1_at_license1.unx.sas.com...
>
> What is the right syntax to do this :
>
> select case ename when ('SCOTT') then 'IIII' else 'CCCC' end as test ,
> ename from emp;
>
> This code returns an error ORA-00923
Received on Thu Nov 02 2000 - 17:31:10 CST
