Mega Code Archive

 

Categories / Oracle PLSQL / Constraints

 

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>