Re: Bad day, or really not possible?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 26 Feb 2002 21:19:17 GMT
Message-ID: <3C7BFBD4.C16FAFD1@ci.seattle.wa.us>

Try the following query:

SELECT keyword
FROM v_$reserved_words;

If it is in the list ... don't use it.

You use of CASE was a very bad choice and will need to be changed.

Daniel Morgan

Jon Waterhouse wrote:

> 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 - 15:19:17 CST