Question: what is the difference between null and empty in oracle?
Answer: A NULL value represents the absence of a value for a record in a field (others software's call it also a missing value). An empty value is a “field-formatted” value with no significant data in it. NULL isn't allocated any memory, the string with NULL value is just a pointer which is pointing to nowhere in memory.