Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64462 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dqm
In theory, a unique key may not contain any nulls. The
reason is simple: the key, by definition is an identifier
and it is illogical to identify something by an unknown.
In practice, some SQL databases permit nulls in unique
keys. Oracle, in particular, allows nulls as long as no
duplicate indices are created in the underlying unique
index. Since Oracle does not create a indices if all
columns are null, the floodgates are open.
For example, for a single column key, this is acceptable
because only the first row makes it to the index:
1
null
null
For a two column key, this is acceptable because in the
first two rows, the first column is unique and the last two
rows, being entirely null, are not represented in the index.
1, null
2, null
null, null
null, null
However, with the same two-column index, this is
unacceptable because the first two rows produce duplicate
inices:
1, null
1, null
null, null
null, null
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are tuples in sql?
What is a primary key example?
What is a system versioned table?
What are % type and % rowtype?
What are the basic techniques of indexing?
Define tables and fields in a database
Why is pl sql needed?
Explain mutating table error.
How is data stored on a disk?
how many columns can be used for creating index? : Sql dba
What is interval partition?
what is a relationship and what are they? : Sql dba
What is dml and ddl?
How many parts of a pl sql block are optional?
