Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

One column with three constraints

SQL> SQL> create table departments   2  ( dname  VARCHAR2(10)  constraint D_DNAME_NN   3                         not null   4                         constraint D_DNAME_UN   5                         unique   6                         constraint D_DNAME_CHK   7                         check (dname = upper(dname))   8  ) ; Table created. SQL> SQL> drop table departments; Table dropped. SQL>