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

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

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