Can we use more than one null value for unique key?

Answer Posted / ashwin

you can insert as many values as u want, in uniquelly
declared column

some people r saying that if u insert more than one null
value in unique column of relation then null is duplicated
which violets unique key property..........well this saying
is totally rubbish......are pehle insert karke dekho phir
bolo as simple as that...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to order siblings in oracle hierarchy queries?

604


which types of join is used in sql widely? : Sql dba

542


What is sql catalog?

570


what is commit? : Sql dba

619


How to add a column ‘salary’ to a table employee_details?

595






Explain the the delete statements in sql?

581


What is scalar function?

569


What is the use of pl/sql table?

558


What is normalization sql?

513


What is sql scripting?

563


Is sql similar to python?

538


Explain what is a view?

600


What are tables and fields?

595


How to read xml file in oracle pl sql?

511


What is the benefit of foreign key?

528