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 disabled using the following syntax:
ALTER TABLE my_table DISABLE CONSTRAINT my_constraint;
Filed under: Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: constraints, database, disable, SQL, unique
