Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

A column with upper case constraint

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>