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
Printable View
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
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;