Comment by johnisgood
6 hours ago
> Oracle treats empty strings as being NULL.
That is ridiculous. Do not they know the difference between "" and NULL?
6 hours ago
> Oracle treats empty strings as being NULL.
That is ridiculous. Do not they know the difference between "" and NULL?
I'm pretty sure the historical reasons I mentioned involved creating the software before the SQL standard came out, meaning they were treating NULL as meaning "nothing", instead of meaning "unknown" as the SQL standard requires. But that's as far as I care to go digging into a database system I will never use of my own free will.