what is unique key?
Answers were Sorted based on User's Feedback
Answer / mapuka mueller
A unique key in sql signifies an attribute of an entity in a
table with the unique constraint, which simply implies that,
that a record(value) of that attribute can not be entered
more than once in that column (except null).
A further assignment of the primary key constraint to that
attribute (or a composite of two or more attributes(columns)
from values on the same row) makes it the unique identifier
of the record(row) in that table.
"It's sometimes hard to express what's in your mind but i
hope i tried"
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shreekumar nair
unique key will only allow unique values in that particular column ...but it allows multiple NULL values ...since null values are not equal to an another null value...
whereas in a primary key column we can't have that ...
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / laya lombi
Is the key which is commonly call as password .
Is This Answer Correct ? | 4 Yes | 14 No |
What are the logical operations?
How to find the duplicate rows count from employees table in oracle?
What is connection pooling in oracle?
"primary key=unique+null" is equal,reson?not,reason?
How do I learn what codesets are available in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
How much memory your 10g xe server is using?
What is the maximum limit on the number of columns in a table?
How do you rate yourself in oracle and sql server ?
What is the difference between count (*), count (expression), count (distinct expression)?
How to convert dates to characters in oracle?
What is rowid and rownum in oracle?