Mega Code Archive

 

Categories / Oracle PLSQL / Constraints

 

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.