Is there a difference between “not null” and “not null enable”?

ENABLE is the default state, so leaving it out has the same effect. The opposite would be to specify DISABLE, in which case the constraint would not be active.

See the constraint documentation for more information.