Add unique containt to a varchar2 type column
SQL> SQL> create table inventory( 2 partno number(4) constraint invent_partno_pk primary key, 3 partdesc varchar2(35) constraint invent_partdesc_uq unique); Table created. SQL> SQL> SQL> SQL> drop table inventory; Table dropped. SQL>