Re: Bad day, or really not possible?

In article <3c7bda8b.0_at_209.128.1.3>, "Jon says...
>
>INSERT into sometable
> (somecolumn)
> SELECT CASE WHEN z <1000 THEN xvalue ELSE yvalue END from someothertable;
>
>Says it's not expecting the symbol case.
>Just not possible, or am I doing something completely silly?
>
>
>
>

816 and up:

ops$tkyte_at_ORA817DEV.US.ORACLE.COM> insert into t ( x )   2 select case when 100 < 200 then 1 else 2 end from dual;

1 row created.

works fine.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp