Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> case ansi 92
It is not possible to use this ANSI 92 clause
SELECT
CASE
WHEN t.c='xx' THEN t.a ELSE t.b
END
FROM t
Oracle does conform to ANSI 92 rules, don't they? How can I rewrite this query in a working version?
Greetings,
Renzo.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jan 19 2000 - 09:10:32 CST