SQL Command (ORACLE) to add constraint with a name

Question

What should be the sql command(oracle) to add 'NOT NULL' constraint, with a constraint name, to a column of existing table?

OldProgrammer · Accepted Answer · 2020-10-28 04:31:55Z

1

 alter table t add constraint my_named_not_null check ( x is not null );

answered Oct 28, 2020 at 4:31

12.2k4 gold badges27 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1