Can we use more than one null value for unique key?
Answer Posted / raman
Primary Key is a combination of Unique and NOT NULL
Constraints so it can’t have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL
but for SQL Server It can have only one NULL
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can unique keys be null?
What is an emotional trigger?
Does execute immediate commit?
what is offset-fetch filter in tsql? : Transact sql
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How many postgresql users are there, worldwide?
The select into statement is most often used to create backup copies of tables or for archiving records?
How many types of triggers are there in pl sql?
Explain locks? : Transact sql
What are the disadvantages of not performing database normalization?
What are the benefits of triggers?
How many parts of a pl sql block are optional?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What are pl sql procedures?
How to pronounce postgresql?