Use Enterprise Manager to Design the table.
Create the new column.
Select the newly created column, right click, Indexes/Keys.
Create a new index on the column name, and make sure to check "Create Unique" before saving amended design.
Any attempt to insert a non-unique value into the new column will result in a Violation of Unique Key Constraint error.
Is this what you wanted to do?