Joey Javas

A unique constraint is used to ensure that a singular value occur only once in a column or that a distinctive combination of values occur only once across a series of columns.

A unique constraint in Oracle can be dropped using the following syntax:

ALTER TABLE my_table DROP CONSTRAINT my_constraint;