Hello
I was checking some not working DB code and found out there is a weird behaviour of checking NULL values:
SELECT LENGTH(NVL(NULL, '')) FROM DUAL;
-> Output: nothing (kinda null, expected: 0)
SELECT LENGTH(NVL(NULL, ' ')) FROM DUAL;
-> Output: 1 (what I expected)
Is there an explanation for this?
Experienced in Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production