In Oracle, column defaults do not function if the column is named in the insert.
Is there any way to change this behavior short of writing an insert trigger to replace null values with default values? Perhaps a database setting or some other nifty trick?
My only other alternative is to change my program to exclude columns for which it has no values, thus allowing the DEFAULT value to function properly, but this would be an ever bigger pain than creating the insert trigger.
Any thoughts?
Is there any way to change this behavior short of writing an insert trigger to replace null values with default values? Perhaps a database setting or some other nifty trick?
My only other alternative is to change my program to exclude columns for which it has no values, thus allowing the DEFAULT value to function properly, but this would be an ever bigger pain than creating the insert trigger.
Any thoughts?
