Unique key

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

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

Also see

• Constraint
• Primary key
• Foreign key

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	#