Was the switch to switch the Oracle empty varchar2 - zero behavior?

Question

As everyone working with Oracle knows that an empty Varchar2 will result in a NULL value when entered into a Varchar2 column.

I (and the employee) thought we read about a parameter that can be set in the database to change this behavior and actually distinguish between null values ​​and empty strings.

Is there such a parameter in new versions? (We think with 10g)

Or is there a parameter that we can confuse with it?

Answer 1

No, Oracle internally saves blank lines and zeros the same way, so it cannot tell whether it wants it or not! Both are stored as a null character and other data.