I need to understand how to add a unique constraint statement to
make sure that all rows have distinct values. How do you alter a
unique constraint column value to make it into a primary key constraint?
Unique constraints are like alternative primary key
- A unique constraint defines a column, or series of columns, that
must be unique in value.
- You can have a number of unique constraints defined and
the columns can have NULL values in them, unlike a column that belongs to a
primary key constraint.
- If you need to add unique key constraints to a table
after the fact, simply use the alter table command.
Normally, a unique constreaint is the same functinally as a unique
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.