Unique key

From Oracle FAQ
Jump to: navigation, search

A unique key is used to uniquely identify rows in an Oracle table. There can be one and only one row for each unique key value.

Example[edit]

CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30) UNIQUE);

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #