Search

NOT NULL



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));