Create a table with 'unique deferrable initially immediate' : Unique « Constraints « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Constraints
  3. Unique

Create a table with 'unique deferrable initially immediate'

   
SQL>
SQL>
SQL> create table inventory(
  2  partno number(4) constraint partno_pk primary key deferrable initially immediate,
  3  partdesc varchar2(35) constraint partdesc_uq unique deferrable initially immediate);

Table created.

SQL>
SQL>
SQL> drop table inventory;

Table dropped.

SQL>
SQL>
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.Add unique containt to a varchar2 type column
5.Add unique constraints
6.ORA-00001: unique constraint (JAVA2S.JOB_UNIQUE_IN_TEAMID) violated
7.Setting a Unique Constraint
8.Unique value column