Vialate the unique contraint: try to insert the same value : Unique « Constraints « Oracle PL / SQL





Vialate the unique contraint: try to insert the same value

  


SQL> --Unique Key
SQL>
SQL>
SQL> create table myTable (
  2    a number unique,
  3    b number
  4  );

Table created.

SQL>
SQL> desc myTable;
 Name                                                                                                  Null?    Type
 ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------

 A                                                                                                      NUMBER
 B                                                                                                      NUMBER

SQL>
SQL> insert into myTable values (4,   5);

1 row created.

SQL> insert into myTable values (2,   1);

1 row created.

SQL> insert into myTable values (2,   1); -- Dup
  2  insert into myTable values (9,   8);
insert into myTable values (2,   1); -- Dup
                                   *
ERROR at line 1:
ORA-00911: invalid character


SQL> insert into myTable values (6,   9);

1 row created.

SQL> insert into myTable values (null,9);

1 row created.

SQL> insert into myTable values (null,9);

1 row created.

SQL>
SQL> select * from myTable;

         A          B
---------- ----------
         4          5
         2          1
         6          9
                    9
                    9

SQL>
SQL> drop table myTable;

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.A unique constraint can be extended over multiple columns
3.Add unique containt to a varchar2 type column
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