Unique value column : Unique « Constraints « Oracle PL / SQL

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

Unique value column

   

SQL>
SQL>
SQL>
SQL> create table t  ( x int unique );

Table created.

SQL> insert into t values ( 1 );

1 row created.

SQL> insert into t values ( 2 );

1 row created.

SQL> update t set x = x+1;

2 rows updated.

SQL>
SQL> drop table t;

Table dropped.

SQL>

   
    
    
  

Related examples in the same category