Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Bad day, or really not possible?
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? Received on Tue Feb 26 2002 - 12:59:11 CST