Hi,

As far as I know, if I define a column as varchar2(or other char data type) in Oracle and insert an empty string to that column, Oracle will treat this column the same as null. This implementation is NOT the same as sql server, which can differentiate an empty string and a null value.

So is this a configurable feature? i.e. can we change some settings so Oracle can also tell the difference between an empty string and null?

Any workaround on it?

Thanks,
Elaine