Oracle generates a check constraint for a not null column. Is there are anywhy to change this behavior ?
For example, consider the following query :
create table abc(a varchar(1) not null)
For the above query, Oracle creates a check constraint for this. It adds an entry in user_constraints with the search_condition value set to ' "A" is not null '. I do not prefer to generate check constraint for not null columns. Is there anywhy to customize this behavior ?