SQL>
SQL> create table departments
2 ( location VARCHAR2(8) constraint D_LOC_NN
3 not null
4 constraint D_LOC_CHK
5 check (location = upper(location))
6 ) ;
Table created.
SQL>
SQL> drop table departments;
Table dropped.
SQL>