NOT NULL CONSTRAINT : NOT NULL « Constraints « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Constraints
  3. NOT NULL

NOT NULL CONSTRAINT

   
SQL>
SQL> CREATE TABLE person (
  2       person_code VARCHAR2(3),
  3       first_name  VARCHAR2(15),
  4       last_name   VARCHAR2(20),
  5       hire_date   DATE
  6       );

Table created.

SQL>
SQL>
SQL>
SQL> ALTER TABLE person MODIFY (first_name NOT NULL);

Table altered.

SQL> ALTER TABLE person MODIFY (last_name NOT NULL);

Table altered.

SQL>
SQL> INSERT INTO person VALUES ('XL', 'Xaviera', NULL, '15-NOV-03');
INSERT INTO person VALUES ('XL', 'Xaviera', NULL, '15-NOV-03')
                                            *
ERROR at line 1:
ORA-01400: cannot insert NULL into ("JAVA2S"."PERSON"."LAST_NAME")


SQL>
SQL> drop table person;

Table dropped.

SQL>
SQL>








Related examples in the same category

1.NOT NULL Column Constraints
2.Change a column to 'not null' with null data in it
3.Adding constraint that checks values and prohobits nulls
4.Create a SQL collection type that disallows null values
5.ORA-01400: cannot insert NULL into
6.Add not null constraint to different columns
7.alter table dept modify emp_count NOT NULL