Add not null constraint to different columns : NOT NULL « Constraints « Oracle PL / SQL






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

Add not null constraint to different columns

  

SQL> create table myTable (
  2        id                   number(8) not null,
  3        code                 number(4) not null,
  4        inception            date not null,
  5        description          varchar2(60) not null,
  6        price                number(6,2) not null,
  7        in_stock             varchar2(1)
  8  );

Table created.

SQL>
SQL> drop table myTable;

Table dropped.








Related examples in the same category

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