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>