xxxxxxxxxx
ALTER TABLE table_name
ADD CONSTRAINT constraint_name UNIQUE (column1, column2, column_n);
xxxxxxxxxx
ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col_name);
ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col1, col2); -- Multiple
ALTER TABLE table_name ADD col_name NUMBER UNIQUE; -- New field