Hi all!
How do I read a boolean value from a select statement if a cell value is NULL?
Usingmysql, you can do such a thing by:
SELECT (NULL IS NULL) AS X;
Returns: 1, else 0.
But, how can that be done in Oracle? If I try
SELECT NULL is NULL AS zerocheck FROM dual;
I recieve: ORA-00923 keyword FROM found anywhere else as it should be (translated error message...)
May anyone give me the statement for the task of NULL checking?
regards, Alex