Can we insert multiple nulls through unique constraints ?

Questions by sachinkshd

Showing Answers 1 - 75 of 81 Answers

santanu

  • Jul 19th, 2012
 

yes

  Was this answer useful?  Yes

Dharmendra Patel

  • Jul 20th, 2012
 

Yes we can insert multiple nulls as each nulls have different ROWID

  Was this answer useful?  Yes

siva

  • Jul 7th, 2014
 

By using single bit mechanism 1 null is big then 2nd null......

  Was this answer useful?  Yes

Ashok

  • Sep 4th, 2014
 

We can insert multiple nulls , as one null value is not equal to another null value.

  Was this answer useful?  Yes

sapna

  • Sep 12th, 2014
 

yes

  Was this answer useful?  Yes

hema nagaraju

  • Dec 20th, 2014
 

we can insert multiple nulls because we cannot compare one null value with another one

  Was this answer useful?  Yes

Avaya

  • Jan 2nd, 2015
 

As NULL does not have any physical existence , we can insert multiple NULL values in a Unique field.

  Was this answer useful?  Yes

Techie

  • Jan 20th, 2015
 

We can insert only one Null value in a column with unique constraint.

  Was this answer useful?  Yes

sai

  • Jan 22nd, 2015
 

yes we can insert multiple null values into one field because null is not a value its a state

  Was this answer useful?  Yes

krishna

  • Feb 9th, 2015
 

Yes ,we can insert multiple nulls through unique contraints because null is not equal to null

  Was this answer useful?  Yes

Abhijit Musale

  • Feb 18th, 2015
 

If ur unique contains only one column then u can insert only one null. If u have 2 then u can insert two null values but with different combinations like (1,null) and (null,1).

  Was this answer useful?  Yes

Shri

  • Feb 27th, 2015
 

Yes we can insert multiple null values as UNIQUE constraint allows multiple null values to insert and also one null value cannot be compared with another null value.

  Was this answer useful?  Yes

PRAMODH

  • Apr 1st, 2016
 

No Two Null Values are Same.

  Was this answer useful?  Yes

JAVED KHAN

  • Apr 6th, 2016
 

Yes, because null is not equal to another null.

  Was this answer useful?  Yes

Hussain Delhiwala

  • Apr 11th, 2016
 

Yes we can insert multiple null values in the table through unique constraints

  Was this answer useful?  Yes

Abhishek Jaiswal

  • Apr 23rd, 2016
 

No, Unique constraint allow a single null value only.

  Was this answer useful?  Yes

Vijaya

  • Apr 27th, 2016
 

We can insert the multiple nulls through the Unique Constraint. It will accept the multiple nulls.

  Was this answer useful?  Yes

Ashish

  • Apr 30th, 2016
 

We cannot insert multiple NULL value unique constraint column. We can insert only one NULL value in unique key constraint. Because when we insert first NULL value then it accept, but when we try to insert new NULL value then its seems like duplicate, and unique key constraint not allow duplicate value. That is why it is not take multiple NULL values.

  Was this answer useful?  Yes

Habib Ali

  • May 10th, 2016
 

Only 1 row in entire table can have a NULL value for the column, defined as unique constraint

  Was this answer useful?  Yes

Asit

  • May 20th, 2016
 

Yes we can insert multiple nulls to a unique key column, as null are garbage value and oracle take a value for the null as well. we all know null !=null

  Was this answer useful?  Yes

bala

  • May 27th, 2016
 

Yes, in Oracle DB it is posible

  Was this answer useful?  Yes

Devesh Kumar Shrivastav

  • Jun 17th, 2016
 

YES, Because the NULL values are used as placeholders or as the default entry in columns to indicate that no actual data is present and also two null data equls with null data. thats why we can insert multiple nulls througt the unique constraints.

  Was this answer useful?  Yes

jithendhar

  • Sep 12th, 2016
 

No, We cannot insert multiple nulls in unique constraint field.

  Was this answer useful?  Yes

Amit Thorat

  • Dec 19th, 2016
 

The correct answer is no: The unique constraint doesnt let you add multiple records that contain a value of NULL. ... In general, a value of NULL isnt equal to NULL, but two different NULL values are treated as equal for the purpose of enforcing a unique index.

  Was this answer useful?  Yes

Piyush Kumar Sharma

  • Dec 28th, 2016
 

We can insert multiple NULL values in Unique key constraints.

  Was this answer useful?  Yes

tejascool

  • May 23rd, 2017
 

A unique key constraint can be applied to single field or combination of fields which uniquely identifies a record.
unique key constraint allows null values as null !=null. so multiple null values are allowed

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions