Question discussion

The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs

307808Medium 1 reply 972 views

Discussion 1

0
CCommunity
Nothing

Since Null is not a member of any data domain, it is not considered a "value", but rather a marker (or placeholder) indicating the absence the value. Because of this, comparisons with Null can never result in either True or False, but always in a third logical result,as Unknown. So, comparing NULL with NULL results to NULL.