Add unique containt to a varchar2 type column : Unique « Constraints « Oracle PL / SQL






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>

   
    
  








Related examples in the same category

1.if a column is not explicitely defined as not null, nulls can be inserted multiple times
2.Vialate the unique contraint: try to insert the same value
3.A unique constraint can be extended over multiple columns
4.Create a table with 'unique deferrable initially immediate'
5.Add unique constraints
6.ORA-00001: unique constraint (JAVA2S.JOB_UNIQUE_IN_TEAMID) violated
7.Setting a Unique Constraint
8.Unique value column