sql - Is it possible to store '' (empty string) as a non NULL value in the database? -


I am using Oracle DB at the database level, when you tap the column value or '' (empty string) If set, the faked value is taped in both cases. Is it possible to store '' (empty string) in the database as a non-zero value?

I execute it

  UPDATE contacts SET last_name = '' WHERE id = '1001'; Committed; SELECT Last_name, contacts with id WHERE id = '1001'; LAST_NAME ID ------------ ------ zero 1001  

Is it possible to store the last_name as a non-zero empty string (' ')?

The only way to do this in Oracle is with any type of assistant flag area, when set It is believed to represent the fact that the value should be an empty string.


Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -