Case in 8i

[bang_dba]

Hi,
Does "CASE" work in 8i (8.1.7)

I have to test some sql queries in different database. Before starting,wanted to make sure whether case works in 8i or not.

Right now i dont have access to 8i, to test the same.

Thx

[andrejm]

SQL WORKS BUT IN PL/SQL DOES NOT...

WORKS IN 8
SELECT CASE WHEN 1=1 THEN 1
WHEN 2=2 THEN 2 END ena FROM dual;


DOSENT WORKS IN 81 BUT IT WORKS IN 9...

DECLARE
x NUMBER;
BEGIN
SELECT CASE WHEN 1=1 THEN 1
WHEN 2=2 THEN 2 END ena
INTO x
FROM dual;
END;