@morbiuswilters said:
I understood that, I just found it rather ridiculous. An empty string is not the same thing as NULL and should not be treated the same. So essentially Oracle has a flawed implementation of three value logic.
Try working in coldFusion. One of the many WTF's of that piece of shit language is that queires returned from the database automatically concert NULL values to empty strings. Couldn't agree more. An empty string is NOT the same as a NULL value.