This is used to avoid null values.
We can add this constraint in column level
only.
Ex:
SQL> create table student12(no
number(2) not null, name varchar(10), marks
number(3));
SQL> create table student12(no
number(2) constraint nn not null, name varchar(10),
marks number(3));