I know that it does consider ' ' as
NULL, but that doesn't do much to tell me why this is the case. As I understand the SQL specifications, ' ' is not the same as
NULL -- one is a valid datum, and the other is indicating the absence of that same information.
Feel free to speculate, but please indicate if that's the case. If there's anyone from Oracle who can comment on it, that'd be fantastic!