create a table with a not-null column, that can receive a value either by having a default or by a trigger:
Code: Select all
create table NotNullTest
(
MyColumn Integer default 1 not null
)
You will get an ORA-1400, which desn't make any sense.
Except when having a fixed column list for the insert statement, which would be wrong for this kind of application.