oracle add unique constraint to column
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