Hello, please, can someone explain this behavior?
SELECT CASE WHEN '' IS NOT NULL THEN 'result' END FROM dual;
--> null
Ok, so '' is null. But when I add "ELSE NULL", suddenly '' IS NOT NULL:
SELECT CASE WHEN '' IS NOT NULL THEN 'result' ELSE NULL END FROM dual;
--> 'result'
Thanks...