Can we use more than one null value for unique key?
Answer Posted / hassan khan
A unique key constraint does not imply the NOT NULL
constraint in practice. Because NULL is not an actual value
(it represents the lack of a value), when two rows are
compared, and both rows have NULL in a column, the column
values are not considered to be equal. Thus, in order for a
unique key to uniquely identify each row in a table, NULL
values must not be used. According to the SQL standard and
Relational Model theory, a unique key (unique constraint)
should accept NULL in several rows/tuples — however not all
RDBMS implement this feature correctly.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
explain the difference between delete , truncate and drop commands? : Sql dba
Can we use ddl commands in pl sql?
What is fmtonly in sql?
When sql appeared?
define join and explain different type of joins? : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?
Show the cursor attributes of pl/sql.
What is varray in pl sql?
Does a primary key have to be a number?
What is pl sql commands?
how to use like conditions? : Sql dba
Define the select into statement.
How do I run a pl sql procedure in sql developer?
Can there be 2 primary keys in a table?
What is sql profiling in oracle?