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
How do I create a sql script?
Explain spool.
Is it possible to create the following trigger: before or after update trigger for each row?
How many times can we commit in a loop?
what is error ora-03113: end-of-file on communication channel?
What is bind reference and how can it be created?
how to concatenate two character strings? : Sql dba
What is a pl/sql block?
Which constraints we can use while creating database in sql?
Is sql a backend?
How many postgresql users are there, worldwide?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Do foreign keys improve performance?
how to create a test table in your mysql server? : Sql dba
What are procedures used for?