Tuesday, 22 September 2020

Various use of CASE statement

Q. Which query return different value?

1. SELECT CASE 0 WHEN 0 THEN 'A' ELSE 'B' END
FROM DUAL;
2. SELECT CASE WHEN 0 = 0 THEN 'A' ELSE 'B' END
FROM DUAL;
3. SELECT CASE NULL WHEN NULL THEN 'A' ELSE 'B' END
FROM DUAL;
4. SELECT CASE WHEN NULL IS NULL THEN 'A' ELSE 'B' END
FROM DUAL;

No comments:

Post a Comment

ORA-01436: CONNECT BY loop in user data

            SELECT CASE                      WHEN CONNECT_BY_ISLEAF = 1 THEN 0                      WHEN LEVEL = 1 THEN 1                   ...