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 |
how to get last monday of a month?
Explain what are the uses of rollback segment?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the sid in oracle?
How to check the server version in oracle?
What are temporal data types in oracle?
i want department wise maxmum salary and empolyee name
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
what is difference between foreign key and reference key
What are the different types of failures that occur in Oracle database?
Explain drop constraint oracle?
Explain the use of owner option in exp command.