take default values if null is passed
3351Jan 21 2004 — edited Jan 21 2004Hi All
I would like to know if this possible in oracle.
I have certain columns in a table which are mandatory(not null)
I have default values for these columns attached
Now ideally only when we skip these columns while insert into the table, are the default values attached to the newly inserted rows.
But what i want is to have the default values attached to the new rows even when the insert statement is trying to insert a null value table & not raise a not null constraint
is this possible , if yes can somebody ellaborate
Rgrds