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;
