case-1:
[c]sql> create table student(stu_id number(4)constraint Stud12_stu_id_nn not null,stu_name varchar(255)not null,fee (7,2));
Query OK, 0 rows affected (0.41 sec)
sql>insert into student values(1001,'jack',12000);
Query OK, 1 row affected (0.10 sec)
sql> insert into student values(null,'jack',12000);
ERROR 1048 (23000): Column 'stu_id' cannot be null[/c]
case-2:
[c]sql> create table student(stu_id number(4),stu_name varchar(255)constraint Studtent_stu_name_nn not null,fee (7,2));
Query OK, 0 rows affected (0.41 sec)
sql>insert into student values(10,'mike',15000);
Query OK, 1 row affected (0.10 sec)
sql> insert into student values(11,'null',16000);
ERROR 1048 (23000): Column 'stu_name' cannot be null[/c]
In the above two example if not null constraint is applied on a column_name stud_id and stu_name then that column will accept the values other than null values.